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.

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.

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).

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

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

Read More: How to Copy Formatting in 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.

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

➤ 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).

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).

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

Read More: How to Copy Cell Format in Excel

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.

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

➤ 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).

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

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

Read More: How to Custom Format Cells in Excel

Similar Readings

• Formula to Copy Cell Value and Format in Excel (5 Uses)
• How to Format Cell Based on Formula in Excel (13 Examples)
• Change Time Format in Excel (4 Ways)
• How to Copy Formatting in Excel to Another Sheet (4 Ways)
• [Fixed!] Format Painter Not Working in Excel (3 Possible Solutions)

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.

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

➤ 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).

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

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

Read More: How to Use Excel Cell Format Formula

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.

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

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

After that, a Module will be created.

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.

➤ Press F5.

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

Read More: How to Use Format Painter in Excel for Multiple Sheets

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.

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.

Further Readings

• VBA to Format Cell in Excel
• How to Repeat Formula Pattern in Excel (Easiest 8 ways)
• Format Text Using Excel VBA (12 Methods)
• Dealing with Time Format in Excel (5 Suitable Ways)
• Uses of CELL Color A1 in Excel (3 Examples)
• How to Use Format Painter Multiple Times in Excel (5 Easy Ways)