How to make all merged cells the same size
By
SpreadCheaters
Page last updated:
11/10/2022 |
Next review date:
11/10/2024
Merged cells could affect the layout of the other data in the worksheet. So it is important to set the size of the merged cells in a proper way, to make all the other data visible. To do that proceed as follows.
Step 1 – Select the merged cells
– Move the mouse upon the column header of the first cell of the merged ones;
– Select all the merged cells by left clicking on the mouse and moving the cursor.
Step 2 – Set the same size for all the merged cells
– Move the mouse between two of the merged column headers;
– When the black row icon appears, press the mouse left button and at the same time move the cursor right or left to increase or decrease the cell’s width. A label with the cell’s width will appear, showing the real time dimension.
