Can I edit headers/footers for an entire workbook?

[On Line All The Time]

Currently I am selecting each page in the workbook and editing each one --
there must be a faster way!

[Zack Barresse]

Of course there is!

Select each sheet (tab) while holding the Ctrl key. Once you have your
array of worksheets selected, goto File | Page Setup | Headers and Footers
... you know how to do it. From there, after you Ok out of that, just
right-click any selected sheet and click Ungroup Sheets.

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.


"On Line All The Time" <On Line All The Time@discussions.microsoft.com>
wrote in message news:982B0F4B-ECF8-423E-AFD2-FE47C0770409@microsoft.com...
> Currently I am selecting each page in the workbook and editing each one --
> there must be a faster way!

[Dave Peterson]

You can group the sheets (click on the first tab and ctrl-click on subsequent
tabs). Then File|page setup and change the headers/footers.

Remember to ungroup the sheets (just rightclick on any of the grouped sheets and
select ungroup sheets) or you may damage your workbook. Almost anything you do
to a one sheet (of a group) is done to the rest of the sheets in that group.

On Line All The Time wrote:
>
> Currently I am selecting each page in the workbook and editing each one --
> there must be a faster way!

--

Dave Peterson