When you choose merge cells, Excel will just merge the selected cells regardless of if they are in the same row or column. As long as they are adjoining and they are selected they will merge.

To use the Format Painter, select the cell or cells whose formatting you want to copy, and click "Format Painter" in the Clipboard group of the Home tab on the ribbon. Excel will then place a ...

This post will show us how to copy only visible cells in Excel & Google Sheets. When working with grouped or hidden rows/columns, you may require to copy only visible cells. If you copy these ...