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

Posted: February 26, 2014

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.

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Join our free insiders Group!

Learn how to SAVE TIME and WORK SMARTER, without the 'techie' speak!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Join our free insiders club! 

Receive 100+ Steps to Becoming Proficient in Excel