Format Painter (Excel Shortcut)

puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

Format Painter in Excel is a feature that is used to copy and paste only the formatting of the cells.

It copies and pastes all the formatting applied to the cells like background color, font color, font size, borders, number format, etc. So, with this user can paste only the cell formatting and exclude the value.

Users can use Format Painter manually or using keyboard shortcuts and, in this tutorial, we have explained a keyboard shortcut to use Format Painter.

Keyboard Shortcut to Format Painter in the Excel

You will find multiple keyboard shortcuts to use Format Painter but we have explained the best and quickest keyboard shortcut below:

Ctrl + Alt + VT

Steps to Format Painter Using Keyboard Shortcut

  1. First, go to the cell or range of cells, whose formatting you want to copy and paste and press the Ctrl + C keys to copy the cells.
  2. After that go to the cell, where you want to paste the cell formatting and press and hold the Ctrl + Alt keys and then press V to get the “Paste Special” dialog box opened and then release the keys.
  3. Now, press T to move the radio button to the “Formats” option, and then press the Enter key and your formatting will get pasted.
paste-special-dialog-box
Last Updated: May 23, 2024