Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Formatting cells

excel training - Formatting cells

ResolvedVersion Standard

Thu 6 Dec 2007, 17:04 Delegate Tess said...

Tess has attended:
Excel Intermediate course

Formatting cells

How do I copy the format of one cell to another?

Mon 10 Dec 2007, 15:50 Trainer Carlos said...

RE: Formatting cells

Tess

The quickest way to do this is to select the cell being copied. Then

Click the [b]Format Painter[/B] icon on the toolbar (next to the paste icon)

Click on the cell to be formatted

The cell takes up the format of the original cell

Hope this helps

Carlos

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel training - Formatting cells

Formatting cells

RE: Formatting cells

Excel articles

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010