Question
How do I use Format Painter to copy the formatting of cells in Excel?
Answer
You will find Format Painter in the Clipboard group on the Home tab. Format Painter will help you quickly copy things such as borders, fills, text formats, or number formats) and apply that formatting to other cells. Click a cell that has the formatting that you want to copy.
Do one of the following:
- To copy the formatting to a single cell or range of cells, click Format Painter, and then drag the mouse pointer across the cell or range of cells that you want to format.
- To copy the formatting to several cells or ranges of cells, double-click Format Painter, and then drag the mouse pointer across each cell or range of cells that you want to format. When you're done, either click Format Painter again or press ESC to turn it off.
For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1
If you need further assistance, please click the CTL Support Request button on this page.