3 Format Painter Tricks in Excel
Below are some ingenious format painter tricks to copy formatting in Excel. And we can bet you don’t know some of them. 😎
How to Use the Excel Format Painter on Multiple Non-adjacent Cells
Okay, so you can copy formatting in Excel using Format painter, But how do you copy the format to non-adjacent cells?
Well, here’s a trick for that.
1. Select the cell you want to copy the formatting of.
2. Double click format painter option on the Home Tab.
3. Select the non-contiguous cells you want to paste formatting to.
4. The formatting appears.
How to Use Format Painter on an Entire Column
The Format painter option works well when copying formats of multiple cells. But what if you want to copy the formatting to an entire column or row?
There are two common ways to copy the formats of one column to another. One uses the Format Painter, while the other uses the Paste Special option.
1. With the format painter, select a single cell with the desired format.
2. Click the paintbrush icon to copy the formatting.
3. Paste the formatting to multiple rows or the entire column by clicking on its heading.
4. The formatting appears in the column.
5. If you want the column width to be copied as well, ensure the sample column has the same formatting overall.
6. Select the sample column heading and click the format painter button.
7. Click the heading of the target column.
8. The formatting, including the width, appears.
You can also use the Paste Special method.
9. On the same workbook, select the cell heading comprising the formatting.
10. Press CTRL + C or Copy button to copy formatting. A moving border pops up.
11. Select the heading of the column you want to paste formatting to.
12. Right-click on the selected range of cells to paste the formatting.
13. Click on the Paste Special formatting option.
14. The Paste Special dialog box pops up. Click the Formats option.
15. The formatting appears.