excel training - Formatting cells

Resolved · Low Priority · Version 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:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

excel training - Formatting cells

Formatting cells

RE: Formatting cells

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet