View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Can I change Headers and footers in selected Reports at the same .

maybe...

If you're writing about worksheets in the same workbook, 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.



Tester wrote:

--

Dave Peterson