![]() Method-3: Using a Shortcut Key for Pasting Formats Read more : How to Copy Cell Format in Excel 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 Read more: How to Copy Formatting in Excel 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 Comments
Leave a Reply. |