Headers / Footers

[Wsheffield]

Hello,

I'm using Excel 2007 and trying to apply my headers, and footers acorss the entire workbook. Is there not an easy way to do continuous page numbers, w/o going into each worksheet? There has to be right!

Pls help - thanks.

 

[Andrew Poulsom]

Group the worksheets - click the tab of the first then Shift+Click the tab of the last. Remember to ungroup when done.