Adding Tabs

[Mike Cates]

I have Excel 2002. I would like to know how to add extra
tabs at the bottom of a worksheet.

 

[David McRitchie]

Hi Mike,
To add more worksheets manually
Insert, worksheet from the menu

To rename a worksheet
Right Click on the worksheet tab, then rename

To rearrange worksheets
Grab worksheet an drag to another position

If you end up with a lot of worksheets, you would probably want to
put them in alphabetical order which you can do with a macro:
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm#sortallsheets
to install a macro see
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro
more information on worksheets, mainly VBA (macros)
http://www.mvps.org/dmcritchie/excel/sheets.htm

 

[Gord Dibben]

Mike

In addition to David's suggestions.......

The default number of worksheets in a new workbook can be set up to 255 under
Tools>Options>General "sheets in new workbook".

OR perhaps you mean you want a way to see more tabs when you have many.

Right-click on one of the sheet navigation arrows at bottom left side of sheet
tabs to get a menu of tabs.

Gord Dibben Excel MVP

 

[Microsoft]

Huh! Neat! I never thought about trying that; thanks!