how to autonumber excel worksheets as 'Page X of Y'
 

Iam using Microsoft Excel 2000 version and in it Iam unable to insert
Autonumbering of pages in 'Page X of Y' format as we do in Microsoft Word
Header insert Autotext

File Page Setup Header/Footer

"srinivas" wrote:

Iam using Microsoft Excel 2000 version and in it Iam unable to insert
Autonumbering of pages in 'Page X of Y' format as we do in Microsoft Word
Header insert Autotext

But be aware that Excel will number the pages according to how many are in
the current print selection. In other words, if you have 8 sheets you want
numbered from 1 to 8, you'll need to print all 8 sheets at once in order to
have Excel's Page x of y work correctly, generally speaking. You *can* print
a single page correctly numbered by first selecting all pages in the group &
then telling Excel to print a specific page within that group.

"IanRoy" wrote:

File Page Setup Header/Footer

"srinivas" wrote:

Iam using Microsoft Excel 2000 version and in it Iam unable to insert
Autonumbering of pages in 'Page X of Y' format as we do in Microsoft Word
Header insert Autotext