M Mike Cates Aug 24, 2004 #1 I have Excel 2002. I would like to know how to add extra tabs at the bottom of a worksheet.
D David McRitchie Aug 24, 2004 #2 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
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
G Gord Dibben Aug 24, 2004 #3 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
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
