page numbering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please let me know the simplest way in Excel to automatically number pages
like page 1 of 9, 2 of 9, 3 of 9, etc.?

Also, in the future, if I delete a worksheet, then will the system know that
it now needs to be 1 of 8, 2 of 8, 3 of 8, etc.?

Thank you very much.
 
Aamir

To have consective numbering 1 of 9, 2 of 9 etc. when printing all sheets in a
workbook.

Select first sheet tab and right-click and "select all sheets".

File>Page Setup>Headers/Footers.

Select Header or Footer and choose from the built-in page numbering options.

You can do the same when slecting only one worksheet with multiple print
pages.

Deleting a worksheet will not affect the numbering. Excel numbers only what
is there to print.

Note: if you have more than one printed page on each worksheet, the numbering
page 1 of x, page 2 of x is based upon the entire number of printed pages, not
just the number of sheets in a workbook.


Gord Dibben Excel MVP
 
<File> <PageSetUp> <Header-Footer> tab,

Expand the "Footer" window, and you'll find some default settings, one of
which will be "Page 1 of ?".

And if you delete a sheet, the numbers will change.

Now, to have your sheets numbered, make sure you select all the tabs before
printing.
Also, assuming that each sheet will fit on a single page.
 
Gord---Also awesome! Thank you.

Gord Dibben said:
Aamir

To have consective numbering 1 of 9, 2 of 9 etc. when printing all sheets in a
workbook.

Select first sheet tab and right-click and "select all sheets".

File>Page Setup>Headers/Footers.

Select Header or Footer and choose from the built-in page numbering options.

You can do the same when slecting only one worksheet with multiple print
pages.

Deleting a worksheet will not affect the numbering. Excel numbers only what
is there to print.

Note: if you have more than one printed page on each worksheet, the numbering
page 1 of x, page 2 of x is based upon the entire number of printed pages, not
just the number of sheets in a workbook.


Gord Dibben Excel MVP
Click to expand...
 
Back
Top