View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default add new info to each page of 40 page workbook

Right-click on a sheet tab then click on Select All Sheets. This will
group the sheets together, such that anything you do on one sheet will
be reflected on all the other sheets. So, you can make your changes
and it will affect all grouped sheets.

Don't forget to right click on a sheet tab and click on Ungroup Sheets
when you are finished.

Hope this helps.

Pete

On Nov 28, 10:42*am, jenjam wrote:
I have a 40 page workbook that I have to add new info to on occasion. The
info needs to be on every page and I have been typing it on page one then
copying and pasting it to the other 39 pages individually, I was hoping
someone would be able to tell me if there is an easier way to do this.