So, the copy and paste feature is very useful.Īs now you know how to copy and paste exact formatting in excel, you can be more efficient and save a lot of time.You probably copy and paste multiple times per day. So, doing the same formatting, again and again, takes up a lot of time. Many people use a template or similar formatting according to their client’s or company’s requirements. You can see that only the format has been copied, no values or formula has been copied in the cell(s) you selected. Now, select the cell(s) you want the formatting in, and you are good to go. You will see a paintbrush which ensures that the format painter is active. Select the formatted cell and then select Format Painter from the Home ribbon. There is another way to copy and paste exact formatting in excel. #2 Using the Format Painter to Copy and Paste Exact Formatting in Excel Now, you can see that only the formatting has been copied. From that box, select Formats and press ok. 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.

How to copy formatting shortcut