About 183,000 results
Open links in new tab
  1. 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.

    1. Select the text or graphic that has the formatting that you want to copy.

    2. On the Home tab, select Format Painter in the Clipboard group. 

    3. The cursor changes to a paintbrush icon.

    4. 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. 

    5. 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).

  2. People also ask
  3. 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 …

    Missing:

    • GIF

    Must include:

  4. Use the Format Painter - Microsoft Support

  5. 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 …

    Missing:

    • GIF

    Must include:

  6. Video: Copy formatting - Microsoft Support

  7. How to Reference Data from Another Sheet in Excel - Software …

  8. 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 …

    Missing:

    • GIF

    Must include:

  9. 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 …

    Missing:

    • GIF

    Must include:

  10. 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.

    Missing:

    • GIF

    Must include:

  11. How to Use Format Painter in Excel: A Step-by-Step Guide

  12. How to use the format painter (video) - Exceljet