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.