Excel 2007 : copy one thing through many sheets

**tayla** · 04-14-2010, 08:06 PM

hi, i have a spreadsheet going that is about 100 pages long. most of these pages contain exactly the same information. is there any way that if i make a change to one page it can be reflected through all of the other pages without me having to copy and paste the change 100 times?

**Paul** · 04-14-2010, 09:26 PM

Hi Tayla, welcome to the forum.

A quick option would be to do the following:

Let's say you want to change cell A4 on Sheet1, Sheet2, Sheet3, Sheet4 ... Sheet100 at the same time. Click Sheet1's tab, then hold down SHIFT and click on Sheet100's tab. That will select every sheet between the two (including Sheet1 and 100). Any change you make at that point will be made on all 100 sheets.

Be careful though.. once you're done making the change, right-click on one of the selected tabs and ungroup them.