Page numbering

[rsgyani]

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.

 

[Pete_UK]

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