View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Grouped sheets page formatting will copy the header

Don't edit the header while the sheets are grouped together - this
includes just selecting the header to have a look at it, as Excel will
assume that you have changed something and will then apply it to all
the grouped sheets.

Hope this helps.

Pete

On Dec 7, 7:09*pm, James Trujillo <James
wrote:
When I select all sheets in a group and format the pages (in page setup), it
copies the header from the first worksheet to all the worksheets. *How can I
stop this from happening?