How to Copy Formatting from one Cell to another in Excel

1.  Left click on the cell with the formatting you want to copy.

how to copy formatting of one cell to another

 

 

2. Click the ‘Format Painter’ command under the Home tab.

How to copy formatting of one cell to another in Excel

 

3. Next, left click on the cell where you want to copy this formatting to.

How to copy formatting of one cell to another in Excel

 

4.  Excel performs the command you want.

 

Lesson 45: How to Create Basic Excel Formulas: Addition, Subtraction, Multiplication, Division