Paul Wherly

Copy Formatting using Autofill in Microsoft Excel 2010

Quick Tip for Microsoft Excel 2010

Here I show you how to copy Formatting using Autofill in Microsoft Excel 2010.

AutoFill also allows you to copy formats from one cell to another.

To copy formatting using Autofill


1. Format the content in your first cell.

2. Position your cursor so it hovers over the bottom right of the cell and it turns into a black cross (1)


3. Click and drag horizontally or vertically to copy – initially it will also perform a content autofill so may overwrite the content already in the cells. Don’t panic, this is only temporary!


4. When you let go, the content is copied but, more importantly, the formatting is also copied.

5. A Smart Tag appears (2)

6. Click on the drop down arrow on the Smart Tag


7. Select Fill Formatting Only from the Smart Tag options


8. The content returns to its previous values, but the formatting is copied across

To fill without copying the formatting

Sometimes you might want to autofill from a cell that is already formatting, in which case the formatting will also be copied.

To prevent the formatting being copied, autofill as usual, then select Fill Without Formatting from the Smart Tag options.

[callout]To learn more about Autofill and to see how we can help your organisation improve their performance with Microsoft Excel give us a call 020 8203 1774[/callout]

Shelley Fishel

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.