Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TNDeb
 
Posts: n/a
Default How do I sequentially number every third page of my workbook?

I have a three page workbook and I want every third page to be numbered
sequentially in the upper right hand corner, is there a formula or macro for
this?
  #2   Report Post  
Zack Barresse
 
Posts: n/a
Default How do I sequentially number every third page of my workbook?

Hello there,

If you go into File | Page Setup | Headers and Footers | Custom Header, put
your cursor in the right-hand box and either click the page icon (with the #
sign on it) or type this in there ...

&[Page]

That will put the page number in the right header.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"TNDeb" wrote in message
...
I have a three page workbook and I want every third page to be numbered
sequentially in the upper right hand corner, is there a formula or macro
for
this?



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
how to rotate page number CliffW Excel Discussion (Misc queries) 0 September 22nd 05 01:03 PM
Is there a function that will return the page number? garyme2 Excel Worksheet Functions 1 July 15th 05 12:15 AM
Excel - turn a page number in a header from horizontal to vertical pbrookstx Charts and Charting in Excel 1 June 4th 05 01:01 AM
How would I remove a pagebreak and page number on a workbook perm. Frustrated New Users to Excel 3 January 15th 05 06:25 PM
How do I print a new number on each page AJ Perkins, Wales, UK Excel Worksheet Functions 1 December 8th 04 03:05 PM


All times are GMT +1. The time now is 01:40 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"