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)
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:
- Select the cell or paragraph containing the format. In this example we are in Excel and cell A1 is selected.
- On the Home tab in the Clipboard group click the Format Painter tool.
- 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.