Use the Same Formatting for Multiple Cells, the Easy Way. – Part 2

Posted on January 29, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

Computer Tips, Tricks, Tweaks and Tutorials - Use the Same Formatting for Multiple Cells, the Easy Way. – Part 2

This next Excel Tip and Trick is a follow-up of the article that I wrote last week about using the same formatting for multiple excel cells. I’m now using also using the Format Painter Tool. In the first article I explained how to copy the format to the second cell and how we can drag the formatting to the cell next to it.

This works great unless the cells don’t connect. I’m using the Format Painter Tool in this Excel Tip and Trick to apply to same formatting in non connecting cells.

For this example I used the same table that I used as the earlier article.

Excel-tip-trick-pic1

If you want to use the same formatting on “random” cells you need to click on cell A1.
And double click on the Format Painter Tool.
Now you can click on the cells you want to apply this formatting on.

Excel-tip-trick-pic2

As you can understand this is quite random and I know it doesn’t make any sense but it’s only for the example;).

You can also apply the Format Painter for columns or rows.

Now I want the same formatting as row 1.

Excel-tip-trick-pic3

Now click on the 1 on the right side of the spreadsheet.
Click on Format Painter
And click on 5

Excel-tip-trick-pic4

And you’re done.

I hope you all like this Excel Tip and Trick. I’ll see all you next time.

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 10 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.