add new info to each page of 40 page workbook

J

jenjam

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.
 
P

Pete_UK

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
 
Top