Use the Same Formatting for Multiple Cells, the Easy Way.

Posted on January 23, 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.

This next Excel Tip and Trick is a pretty cool one and can save you a lot of time. If you are working in a Excel spreadsheet you want it to look nice. But making it nice looking can be a time consuming operation if you don’t do it right. The best and most easy way to do this is to use the Format Painter tool.

I made a small table that I’m using here as an example.

Excel-tip-trick-pic1

For this example I’m now only formatting cell A1

Excel-tip-trick-pic2

Now I want to same formatting as cell A1 on cell B1.

To do this you need to click on cell A1.
Click on Format Painter
And click on Cell B2

Excel-tip-trick-pic3

Now this is for one cell.

If you want to format Cell B1 and C1

you need to click on cell A1.
Click on Format Painter
And drag the cursor from cell B1 to C1.

Excel-tip-trick-pic4

I hope you all enjoyed this time saving Excel tip and Trick. I’ll talk to you all tomorrow!

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 3 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.