How to Copy Cell Formatting in Excel


This wikiHow teaches you how to copy all the conditional formatting properties from a cell in Microsoft Excel, and paste the same formatting to other cells on your spreadsheet. This will help you copy all the color, font, size, border, fill, and alignment properties from a cell at once.

Part 1
Copying Style Formatting

Copying Style Formatting on How to Copy Cell Formatting in Excel

1
Find and double-click the Excel file on your computer to open the spreadsheet in Microsoft Excel.

Copying Style Formatting on How to Copy Cell Formatting in Excel

2
This will select and outline the cell on the spreadsheet. When you copy formatting, all the custom styling elements like the text font, cell border, fill and alignment settings will be copied.

Copying Style Formatting on How to Copy Cell Formatting in Excel

3
This button is in the upper-left corner of your spreadsheet. It will switch the toolbar ribbon to your Home tools. If you're already in this tab, you can skip this step.

Copying Style Formatting on How to Copy Cell Formatting in Excel

4
This button looks like a paintbrush icon in the upper-left corner of the Home toolbar, next to Paste. Your pointer will change to a paintbrush. You can double-click the Format or Format Painter button here if you want to keep using it, and paste the formatting in other cells.

Copying Style Formatting on How to Copy Cell Formatting in Excel

5
This will paste the formatting from your first cell across all the cells in your paintbrush selection. The format painter will only copy styling elements like font, size, fill, border and alignment. It will not copy formulas, data types, functions or calculations.

Part 2
Copying Formulas

Copying Formulas on How to Copy Cell Formatting in Excel

1
Find and double-click the Excel file on your computer to open the spreadsheet in Microsoft Excel.

Copying Formulas on How to Copy Cell Formatting in Excel

2
This will select and outline the formula cell.

Copying Formulas on How to Copy Cell Formatting in Excel

3
You'll find it in the lower-right corner of the cell outline when you click and select your formula cell. Your cursor will turn into a black "+" icon on the green square.

Copying Formulas on How to Copy Cell Formatting in Excel

4
This will expand the cell selection outline, and copy the same formula to all the cells in this direction. This will copy the same formula to all the cells, and shift the data range to the corresponding area for each new formula cell. For example, if you copy a formula from A5 that deals with data from A1 to A3, your formula in B5 will now deal with data from B1 to B3.