Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
srinivas
 
Posts: n/a
Default 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
  #2   Report Post  
IanRoy
 
Posts: n/a
Default

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

  #3   Report Post  
Duke Carey
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I uniformly scale all worksheets at once in page set-up in on. Rob W. Setting up and Configuration of Excel 2 May 3rd 23 03:41 AM
export excel to Front Page judithbear Excel Discussion (Misc queries) 0 March 26th 05 11:17 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM
Excel page break preview RK Excel Discussion (Misc queries) 3 February 17th 05 12:33 AM
How to recover worksheets lost when I opened an Excel file in Wor. Steviek1 Excel Worksheet Functions 0 January 23rd 05 10:53 PM


All times are GMT +1. The time now is 03:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"