Use Format Painter to quickly apply the same formatting, such as color, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the formatting from one object and apply it to another one—think of it as copying and pasting for formatting.
Select the text or graphic that has the formatting that you want to copy.
On the Home tab, select Format Painter in the Clipboard group.
The cursor changes to a paintbrush icon.
Use the brush to paint over a selection of text or graphics to apply the formatting. This only works once. To change the format of multiple selections in your document, you must first double-click Format Painter.
Tip Use Alt+Ctrl+C to copy a format, and Alt+Ctrl+Vto paste a format. While the cursor does not change to a paintbrush, you can repeatedly select text and paste formatting to multiple areas without re-copying.
To stop formatting, press ESC.
Note If you want to copy text formatting, select a portion of a paragraph. If you want to copy text and paragraph formatting, select an entire paragraph, including the paragraph mark.
For graphics, Format Painter works best with drawing objects, such as AutoShapes. However, you can copy formatting from a picture (such as the picture's border).
- People also ask
How to Use Format Painter in Excel (A Definitive Guide) …
Mar 16, 2017 · Excel Format Painter is a nifty tool that allows you to copy formatting from a range of cells and paste it somewhere else in the worksheet (or other worksheets/workbooks). Imagine this! You get plain ugly data from a …
Use the Format Painter - Microsoft Support
How to Use the Format Painter Shortcut in Excel
Jun 17, 2024 · The shortcut sequence to activate Format Painter is “ Alt+H+FP ”. Steps: a) Select the cell that contains the desired formatting. Press ALT, H, F, and P (you have to press these keys individually). Click on the cell or select …
Video: Copy formatting - Microsoft Support
How to Reference Data from Another Sheet in Excel - Software …
How to Use the Format Painter in Excel: Copy …
Aug 29, 2024 · In this article, we learned how to use format painter in excel. From its shortcuts to copying formats of entire columns to secret underused features. We also saw how we could copy formats using alternate methods …
How To Use Format Painter in Excel
Jun 12, 2024 · The Format Painter button in the Excel ribbon or right-click context menu empowers you to visually copy cell formatting from one cell to another. If you often use this tool to copy formatting to multiple cell ranges …
How to Use the Excel Format Painter in 60 Seconds
Feb 27, 2017 · How to Make Data Tables in Excel in 60 Seconds. Excel's Format Painter is one of those key time saving tools for styling your spreadsheets. With the Format Painter, we can quickly apply the styles from one table to another.
How to Use Format Painter in Excel: A Step-by-Step Guide
How to use the format painter (video) - Exceljet