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 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. Finally, R chooses paste only formatting.S will select the paste special command.➤ 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). You can easily paste your desired formatting style to the column Selling Price by following this method. Method-3: Using a Shortcut Key for Pasting Formats In this way, you will be able to paste your desired formatting styles in the Selling Price column. ➤ 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).Īfter 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). ➤ Select the cell in which you have the required format and then press CTRL+C. 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. Method-2: Using Shortcut Key for Paste Special Dialogue Box F, P will finally select the Format Painter optionĪfter that, you will have a Format Painter sign and which you have to drag down all the way to the Selling Price column.Īfterward, you will be able to paste your desired formatting styles in the Selling Price column.ALT activates the keyboard shortcuts for ribbon commands.
0 kommentar(er)
