It can be a pain to have to set up the formatting when it isn’t necessary! Who wants that kind aggravation and time wasting? Certainly not I!
There is a way to copy all formats, including row and column dimensions to your new worksheet without a lot of pain involved.
The one thing you really need to remember is that column widths are the attributes of columns and not cells. Also, row height is an attribute of rows and not cells. What this means to you is that if you want to copy the width of a column to another worksheet,you need to select the entire column before you click on your Format Painter. The same goes for the height of a row, you will have to select the entire row whose format you would like to copy before you click on your Format Painter.
Follow the steps below to learn how:
- Open a worksheet that has custom formatting for rows and columns.
- Select a row or range of rows in your worksheet. Remember, you need to select the entire row, not simply the cells within the rows.
- Just click on the row numbers of the rows you would like to select.
- Click on your Format Painter.
- Open the worksheet where you would like the same formatting.
- Select the rows you would like to apply the formatting to.
Now, the rows in your worksheet should be formatted exactly the same as the rows you selected in your worksheet with the custom formatting.
If you would like to format the entire worksheet just select all columns and rows or click CTRL + A (to select all) .