Now, go to the cell you want to paste the formatting in, right-click, and select Paste Special. You can also use the shortcut CTRL+C to copy. To do that, select the formatted cell, right-click, and copy. So, when we copy to another cell, Excel will paste colors, fonts, borders, etc.

So, our goal is to copy only the formatting (borders, colors, fonts, etc.) and nothing else. In the picture, you can see that, for an example of formatting, I have used a simple sum function. #1 Using the Paste Special to Copy and Paste Exact Formatting in Excel So, let’s look at them one by one and learn how to copy and paste exact formatting in excel. There are two ways you can copy and paste exact formatting in excel. So, Excel, for the convenience of its users, has added a copy and paste feature which can be used in various ways that can reduce time consumption and make the day easy for us. While formatting is important, doing the same formatting over and over again can be tedious, boring, time-consuming, and most of all inefficient in this fast-paced world. How to Copy and Paste Exact Formatting in Excel? So, let’s see how to copy and paste exact formatting in excel. Hence, formatting in excel is also important.įormatting is important because a well-designed and thought-out formatting reduces stress, the content is comfortable to look at and the content becomes visually appealing so consumers of the content are more likely to be attracted. Excel is good at all of the mentioned aspects.

Formatting is an important aspect of data analysis, accounting, graphs, charts, etc.

Copy and paste list into excel