Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Page numbering

When you have grouped the three sheet together, then anything you do
on one sheet will be reflected in the other sheets. From your
description, however, you seem to have done it to one sheet and then
grouped them. However, if you group them again, you can just go into
File | Page Setup | Headers/Footers | Custom Header (as if to edit
what is in there), and then when you exit the various dialogue boxes
and ungroup the sheets you should find that all sheets now have the
same header.

Hope this helps.

Pete

On Apr 17, 5:10*pm, rsgyani wrote:
I want to number all pages but put the &[page] of &[pages] only on one
worksheet. I read the answers from earlier replies but it does not work. I
put the statement on one page and then right clicked on another Tab and
selected "select all sheets". I tested with three worksheets. The first sheet
does show 1 of 3 in the footnote but other sheets do not. Please help.

Thanks.


 
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
start page numbering from page 2 in excel swa Excel Discussion (Misc queries) 2 July 25th 07 04:53 PM
Page Numbering Gaylene Excel Discussion (Misc queries) 5 November 23rd 06 09:58 PM
Format page numbering to be Page 1 of X Joan at UCSF Excel Discussion (Misc queries) 2 April 6th 06 03:31 AM
page numbering ksm1510 Excel Worksheet Functions 1 August 23rd 05 02:48 PM
Page Numbering Silver Excel Discussion (Misc queries) 1 January 13th 05 05:55 PM


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