Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Numbering sheets in workbook
I have a workbook with 5 tabs with 10 sheets in each tab, can I number the
sheets under each tab 1-10 also can I number all sheets 1-50? Also if I add more sheets or tabs can it automatically change the numbers? Thanks a lot. |
#2
|
|||
|
|||
What is your difference between a sheet and a tab? I use
them interchangably. -----Original Message----- I have a workbook with 5 tabs with 10 sheets in each tab, can I number the sheets under each tab 1-10 also can I number all sheets 1- 50? Also if I add more sheets or tabs can it automatically change the numbers? Thanks a lot. . |
#3
|
|||
|
|||
hi,
we are talking excel spreadsheets aren't we? -----Original Message----- I have a workbook with 5 tabs with 10 sheets in each tab, can I number the sheets under each tab 1-10 also can I number all sheets 1- 50? Also if I add more sheets or tabs can it automatically change the numbers? Thanks a lot. . |
#4
|
|||
|
|||
If you mean 5 sheets with 10 pages each,
FilePage Setup at the bottom of the page tab you can type in the first page number for that worksheet. If you clrify that this is what you want, someone will probably be able to write you a code to automate it. On Wed, 2 Mar 2005 09:33:03 -0800, Red wrote: I have a workbook with 5 tabs with 10 sheets in each tab, can I number the sheets under each tab 1-10 also can I number all sheets 1-50? Also if I add more sheets or tabs can it automatically change the numbers? Thanks a lot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically copy selective sheets from one workbook to another | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
copy a workbook from other workbook with lot of sheets wit... | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |