Format Painter | Keyboard Shortcut | Microsoft Excel

HomeExcel Keyboard ShortcutsFormat Painter | Keyboard Shortcut | Microsoft Excel

Format painter in Excel is a feature that is used to copy and paste only the formatting of the cells. Format painter copies and paste 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 excludes 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 most quick keyboard shortcut below:

keyboard-shortcut-to-format-painter

Ctrl + Alt + V → T

Steps to Format Painter Using Keyboard Shortcut

  • 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.
  • After that go to the cell, where you want to paste the cell formatting and press and hold “Ctrl” + “Alt” keys and then press “V” to get the “Paste Special” dialog box opened and then release the keys.
  • 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

➜ Excel Shortcuts Cheat Sheet (PDF)