From that window, click on Paste Special. Now, Right-Click on your Mouse on cell D7.After selecting cell C9, press Ctrl + C on your keyboard.In this method, we’ll copy the format of cell C9. Insert Copy Paste Special to Copy Cell Format in ExcelĪfter learning how to copy cell format by using Format Painter, here we’ll get to learn how to copy cell format by applying Paste Special Command. Related Content: How to Use Format Painter in Excel (7 Ways)Ģ. Finally, you’ll get your desired output which is given in the below screenshot. Now, Left-Click on your Mouse on cell D8.After that, a Format Painter sign will appear in front of you.For copying the format of cell C8, we can apply the Format Painter Command from our Home Tab. Suppose, From our dataset, we want to copy the format of cell C8 where Hanry’s Student ID is situated. Apply the Format Painter Command to Copy Cell Format in Excel Here’s an overview of the dataset of our today’s task.ġ. From this dataset, we will copy some specific formats for the convenience of our work. Let’s say, we have a dataset where some Student Names, Student ID, and their CGPA are given in Column B, Column C, and Column D respectively. 4 Suitable Ways to Copy Cell Format in Excel

Ehow tech how to use format factory