Home » Our Blog » Office – Use the Format Painter to copy formatting (but not the text)

Office – Use the Format Painter to copy formatting (but not the text)

PROBLEM: Wasting time repetitively applying the same formats
within a document.

SOLUTION: copy the formats instead!

Word, Excel, PowerPoint & Outlook 2010, 2013 & 2016 – Copying formatting (without copying the text)
This tip is great for Word, Excel, PowerPoint, Outlook and Access.

The Format Painter tool allows you to copy and paste the format of a paragraph (in Word, PowerPoint or Outlook) or a cell (in Excel) without pasting the content.

To use the Format Painter tool:

  1. Select the cell or paragraph containing the format.  In this example we are in Excel and cell A1 is selected.
  2. On the Home tab in the Clipboard group click the Format Painter tool.
  3. Click the cell or paragraph you wish to format.

Note: if you wish to paint a format to several cells located in different places on a worksheet double-click   Format Painter.  Click to format each cell.  Once you have finished click the Format Painter tool to turn Format Painter off.


If you found this post helpful please ‘Like’ us!