Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page numers consecutive across all tabs in Excel file?
How can I have page numbers automatically go from 1 on the 1st page of the
1st tab of an Excel file all the way into up to the last page in the last tab? My file has about 30 tabs and from 1 to 9 pages per tab. I've seen postings that say "group your worksheets". I've done a "Select All", but then what do I do? Each tab's page numbers still start with "1" in Print Preview. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page numers consecutive across all tabs in Excel file?
Choose FilePage Setup
On the Page tab, for First Page Number, enter: Auto Click OK DanBDT wrote: How can I have page numbers automatically go from 1 on the 1st page of the 1st tab of an Excel file all the way into up to the last page in the last tab? My file has about 30 tabs and from 1 to 9 pages per tab. I've seen postings that say "group your worksheets". I've done a "Select All", but then what do I do? Each tab's page numbers still start with "1" in Print Preview. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I protect all excel tabs in a file with one password entry? | Excel Discussion (Misc queries) | |||
Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) |