#1   Report Post  
ksm1510
 
Posts: n/a
Default page numbering

How do I make the page numbers like 1 of 30 run consecutively
  #2   Report Post  
Richard Neville
 
Posts: n/a
Default

If all 30 pages are in the same sheet, follow these instructions for that
sheet only. If they are split into two or more sheets, you must first group
the affected sheets. Click on the first one, then Ctrl-click on the second,
third, etc.

Go to Page Setup, Header and Footer tab. Click on either Header or Footer,
depending on where you want the page numbers. Click in one of the boxes
(left, center, or right), and a toolbar will appear. You can enter just a
page number, or a string such as "1 of 30," "2 of 30," etc.

For page number only, just click the # icon. For "1 of..." etc., click the #
icon, type space, of, space, and click the +++ icon. Click OK out of the
menu and go to page preview to determine whether it shows what you want.

When printing, if the page numbers are in more than one sheet, all sheets
must be selected. Otherwise the page numbers will start from 1 in each
separate sheet.

"ksm1510" wrote in message
...
How do I make the page numbers like 1 of 30 run consecutively



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
Page Numbering Pam Coleman Excel Discussion (Misc queries) 1 July 29th 05 08:44 PM
Page Numbering between tabs Jeff Excel Discussion (Misc queries) 1 March 21st 05 03:47 PM
Auto page numbering for several worksheets Andy Excel Worksheet Functions 1 March 13th 05 04:41 AM
adding a new page break to an existing page break Edward Letendre Excel Discussion (Misc queries) 1 March 6th 05 09:29 AM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM


All times are GMT +1. The time now is 09:54 PM.

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

About Us

"It's about Microsoft Excel"