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

S

srinivas

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
 
D

Duke Carey

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