Excel Hack

Format painter shortcut in Excel

Excel has a feature called the format painter that allows you to easily copy formatting. Once you learn how to do it, you can easily copy the formatting with a few keystrokes. The format painter is very useful if you want to improve the appearance of your cells by matching the fill color, font, font size, etc.

Format painter shortcut

Call the format painter

Windows
Access Key: Alt + H + F + P

Mac
None

Display the Paste Special dialog box

Windows
Ctrl + Alt + V
Access Key: Alt + E + S

Mac
control + command + V

Copy cell format with the format painter

Learn how to copy the formatting of a cell in the format painter using the shortcut keys.

Total Time: 1 minute

Select a cell

Select a cell

Select the cells of the format to be copied.

Call the format painter

Press Alt + H + F + P

Press Alt + H + F + P to call up the format painter.

The format has been copied

Select the cell you want to change the format to

Click on the cell to which you want to apply the formatting. You can now copy the formatting.

Copy the format from the Paste Special dialog box

Select a cell

Select the cells of the format to be copied.

Press Ctrl + C

Press Ctrl + C to copy the cells.

Press Ctrl + C

Click on the cell to which you want to apply the formatting. Press Ctrl + Alt + V or Alt + E + S.

Press Ctrl + Alt + V, press T

The Paste Special dialog box will appear.

Press T to select formats and press Enter.

The format was copied

The format has been copied.

Copy the format from the context menu

Select a cell

Select the cells of the format to be copied.

Press Ctrl + C

Press Ctrl + C to copy the cells.

Press Ctrl + C

Click on the cell to which you want to apply the formatting.

Press Shift + F10, Press S + R

Press Shift + F10. Press S, then R.

The format was copied

The format has been copied.

Copying the formatting of multiple cells

Select a cell

Select the cell you want to copy the format to.

Press Shift + ↓

Press Shift + (Down Arrow key) to select multiple cells.

Press Alt + H + F + P

Press Alt + H + F + P to call up the format painter.

The format has been copied

Click on the cell to which you want to apply the formatting. This will allow you to copy the formatting of multiple cells.