In this article, we will learn how to use the format painter to copy column widths and row heights in Microsoft Excel.
Format Painter is a basic feature of Excel, which is used to allow one cell to be equal to another one. For example, you have to enter a formula in one cell. After copying the formula, the cell contents will get pasted in the target cell along with the attributes of original cell’s formatting like Bold, Italic, Borders, etc. but width of cell can not be copied.
The format painter feature can be used not only to copy cell formatting, but can also use the format painter to copy column widths and row heights.
Highlight the data that you want to copy, and then click the Format Painter & select the cell in which you want to apply the same formatting.
The column widths are attributes of columns, not of cells. Likewise, row height is an attribute of rows, not of cells. If you want to copy the width of a column to another column, you need to select the entire column & then click on the Format Painter. If you want to copy the height of a row, you need to select the entire row which you want the format to be copied.
- If you are copying the data from range A1:A2 to D1:D2; column width would not be change.
- In order to get the same column width we can use format painter
- Select the whole column A & click on Format painter
- Select column D to make column width similar to column A
- After using format painter; this is how our data looks