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.

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.

Group the pages before you type, then remember to ungroup afterwards.
--
David Biddulph

"jenjam" wrote in message
...
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.