New Tabs

Resolved · Low Priority · Version Standard

Wed 13 Feb 2008, 16:28 Delegate Kevin said...

Kevin has attended:
Excel Introduction course

New Tabs

How do you include extra tabs on the bottom of a page? currently my spreadsheets at work have three and i would like to add more. I have done this in the past but to be honest i dont know what i done as i was pressing various buttons.
Kind Regards

Wed 13 Feb 2008, 16:32 Delegate Paul said...

RE: New Tabs

right click one of your tabs and then click insert.

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

New Tabs

New Tabs

RE: New Tabs

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet