If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding Tabs
I have Excel 2002. I would like to know how to add extra
tabs at the bottom of a worksheet. |
#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...#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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
best way to do tabs | Olivera | Tables | 4 | August 15th, 2004 09:16 PM |
Adding Tabs in a TOC between the caption number and text | Katy White | Formatting Long Documents | 3 | July 30th, 2004 08:34 PM |
tabs word 97 | Jim Henderson | New Users | 0 | April 25th, 2004 07:34 PM |
Adding pull down tabs in a worksheet | maryharrisfmi | Worksheet Functions | 3 | January 7th, 2004 10:55 PM |
Problem with Tabs | Robert B | Worksheet Functions | 2 | October 8th, 2003 08:37 PM |