Page numers consecutive across all tabs in Excel file?

G

Guest

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.
 
D

Debra Dalgleish

Choose File>Page Setup
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

*consecutive* page numbers across all tabs in workbook?? 1
Page Numbers and Multiple Tabs (Excel 2000) 2
Partial printing of entire worksheet (1st or 2nd pages only) 4
Page numbers across multiple tabs - one sequence 3
Page Numbering between tabs 1
Mail Merge With Word, More than 1 Data Source 3
Different font sizes in different worksheet tabs 3
Display page number in footer based upon pages in the current tab 1

Top