Adding Tabs

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

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...#sortallsheets
to install a macro see
http://www.mvps.org/dmcritchie/excel....htm#havemacro
more information on worksheets, mainly VBA (macros)
http://www.mvps.org/dmcritchie/excel/sheets.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mike Cates" wrote in message ...
I have Excel 2002. I would like to know how to add extra
tabs at the bottom of a worksheet.

Mike

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

The default number of worksheets in a new workbook can be set up to 255 under
ToolsOptionsGeneral "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

On Tue, 24 Aug 2004 12:41:42 -0700, "Mike Cates"
wrote:

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

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


"Gord Dibben" gorddibbATshawDOTca wrote in message
...
Mike

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

The default number of worksheets in a new workbook can be set up to 255
under
ToolsOptionsGeneral "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

On Tue, 24 Aug 2004 12:41:42 -0700, "Mike Cates"
wrote:

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