The Format Painter in Excel makes it easy to copy the formatting of a cell and apply it to another. With just a few clicks you can reproduce formatting such as fonts, alignment, text size, border, and background color.
On any Excel worksheet, click on the cell with the formatting you’d like to copy. You will see dashed lines around the selected cell. Then select the Home tab and click on the Format Painter.
You’ll see your cursor now includes a paintbrush graphic. Move to the cell where you’d like to apply the formatting and click on it.
Your target cell will now have the new formatting.
If you double-clicking on Format Painter you can then click on multiple individual files to which to apply the format. Or, you can click and drag across a group of cells. When you are finished applying formats, click on Format Painter again, or on the Esc key, to turn it off.
The Format Painter is a very simple, but extremely useful and time saving tool when creating complex worksheets.
- › How to Use and Create Cell Styles in Microsoft Excel
- › How to Copy Conditional Formatting in Microsoft Excel
- › The Best How-To Geek Articles About Microsoft Office
- › How to Create an Automatic Outline in Microsoft Excel
- › How to Apply Shading to Alternate Rows in Excel
- › How to Convert a Table to a Range and Vice Versa in Microsoft Excel
- › How to Share Cell Styles Across Microsoft Excel Workbooks
- › Proton Mail and Calendar Are Getting Even Better