So, for non-adjacent cells, we have to do this process again and again. ? When we want to copy and paste the desired formatting style using the Format Painter shortcut, we can do it only once. Here, the formatting style of cell C5 will be copied and then it will paste this formatting style in the range D5:D12. Range("D5:D12").PasteSpecial Paste:=xlFormats
➤Write the following code Sub Formatpainter() Then, the Visual Basic Editor will open up. ➤ Go to Developer Tab > Visual Basic Option. You can use a VBA code to easily have your desired formatting styles in the Selling Price column. Method-5: Using a VBA Code as a Format Painter Shortcut Excel
Read more: How to Use Excel Cell Format Formula Then, you will be able to paste your desired formatting styles in the Selling Price column.įor Excel 2007 or older versions, you have to press SHIFT+F10, S, T, ENTER.