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

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

Guest

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.
 

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

i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
no of pages in excel worksheet (not workbook) 9
'Cannot insert object' message when I try to put a button on a worksheet 7
Excel still changes numbers to date 1
Excel VBA help: Text file formatting 19
Copying and pasting with a macro 1
Print Cell Data in heading of pages 4
printing multiple worksheets in a workbook 1

Back
Top