How to Use Format Painter Shortcut in Excel (5 Ways)

If you are looking for some of the easiest ways to use the Format Painter shortcut in Excel, then you will find this article useful. Format Painter is used in Excel to copy the format of one or more cells to other cells.
By using these shortcut techniques, you will be able to do this task in a faster way. So, let’s get into the main article.

Download Workbook


5 Ways to Use Format Painter Shortcut in Excel

Here, we have used the following table for demonstrating the ways of using format painter shortcuts in Excel.

For creating the article, we have used Microsoft Excel 365 version, you can use any other versions according to your convenience.

format painter shortcut Excel


Method-1: Using a Format Painter Shortcut Key 

In this section, we will use a shortcut key for the Format Painter option to have our desired formatting styles in the Selling Price column.

format painter shortcut Excel

Steps:
➤ Select the cell in which you have the required format and press ALT, H, F, P (you have to press these keys one by one).

  • ALT activates the keyboard shortcuts for ribbon commands
  • H selects the Home Tab
  • F, P will finally select the Format Painter option

format painter shortcut Excel

After that, you will have a Format Painter sign and which you have to drag down all the way to the Selling Price column.

format painter shortcut Excel

Result:
Afterward, you will be able to paste your desired formatting styles in the Selling Price column.

format painter shortcut Excel


Method-2: Using Shortcut Key for Paste Special Dialogue Box

Suppose, you want to copy the formatting styles of the cells of the Cost Price column to the Selling Price column and to do this you can use a shortcut key like this method.

paste special dialogue box

Steps:
➤ Select the cell in which you have the required format and then press CTRL+C.

paste special dialogue box

➤ Then you have to select the range of cells where you want to have the formats and press CTRL+ALT+V (you have to press these keys simultaneously).

paste special dialogue box

After that, it will open up the Paste Special dialogue box and here, you have to select the Formats option and then press OK (you can do this by pressing T and ENTER).

paste special dialogue box

Result:
In this way, you will be able to paste your desired formatting styles in the Selling Price column.

paste special dialogue box


Method-3: Using a Shortcut Key for Pasting Formats

You can easily paste your desired formatting style to the column Selling Price by following this method.

format painter shortcut Excel

Steps:
➤ Select the cell in which you have the required format and then press CTRL+C.

shortcut for paste special

➤ Then you have to select the range of cells where you want to have the formats and press ALT, E, S, T, ENTER (you have to press these keys one by one).

  • ALT, E, S will open up the paste special dialogue box
  • T will select the Formats option

shortcut for paste special

After pressing T, you will be able to see that the Formats option has been selected here.

shortcut for paste special

Result:
Finally, after pressing ENTER, you will be able to paste your desired formatting styles in the Selling Price column.

shortcut for paste special


Method-4: Using Paste Special Shortcut Key as a Format Painter Shortcut Excel

You can use a paste special shortcut key for having your desired formatting styles in the Selling Price column.

format painter shortcut Excel

Steps:
➤ Select the cell in which you have the required format and then press CTRL+C.

paste special shortcut key

➤ Then you have to select the range of cells where you want to have the formats and press SHIFT+F10 (you have to press these keys simultaneously), S, R (you have to press these keys one by one).

  • SHIFT+F10 displays the context menu
  • S will select the paste special command
  • Finally, R chooses paste only formatting

paste special shortcut key

Result:
Then, you will be able to paste your desired formatting styles in the Selling Price column.

paste special shortcut key

Note
For Excel 2007 or older versions, you have to press SHIFT+F10, S, T, ENTER.


Method-5: Using a VBA Code as a Format Painter Shortcut Excel

You can use a VBA code to easily have your desired formatting styles in the Selling Price column.

VBA code

Step-01:
➤ Go to Developer Tab >> Visual Basic Option.

VBA code

Then, the Visual Basic Editor will open up.
➤ Go to Insert Tab >> Module Option.

VBA code

After that, a Module will be created.

VBA code

Step-02:
➤Write the following code

Sub Formatpainter()

[C5].Copy
Range("D5:D12").PasteSpecial Paste:=xlFormats

End Sub

Here, the formatting style of cell C5 will be copied and then it will paste this formatting style in the range D5:D12.

VBA code

➤ Press F5.

Result:
In this way, you will be able to paste your desired formatting styles in the Selling Price column.

format painter shortcut Excel


Things to Notice

🔺 When we want to copy and paste the desired formatting style using the Format Painter shortcut, we can do it only once. So, for non-adjacent cells, we have to do this process again and again.

🔺 For non-adjacent cells, you have to copy the formatting style and then double-click on the Format Painter option on the ribbon. By doing this you will be able to lock the Format Painter and then you can do this formatting for as many cells as you want.


Practice Section

For doing practice by yourself we have provided a Practice section like below in a sheet named Practice. Please do it by yourself.

practice


Conclusion

In this article, we have tried to cover the easiest ways to use format painter shortcuts in Excel effectively. Hope you will find it useful. If you have any suggestions or questions, feel free to share them with us.

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo