Link data in a cell in 1 sheet to 99 other sheets

  • Thread starter Thread starter Pointer
  • Start date Start date
P

Pointer

I'm a computer dumb-cluck so everybody knows the answer to this but I
don't and I didn't find it on Google.

I have a workbook with 100 worksheets. I want to enter a number in
cell A1 of the first worksheet and have it appear in cell A1 of all
the other sheets. But I don't want to have to link each of the 99
sheets one-by-one.

So how do I in Excel 97?

Thank you
 
Hi Pointer

I'm unsure if this will work in XL 97 but give it a try.

1) Right click on any sheet tab and select "Select All Sheets".
2) Select cell A1 of the active sheet and enter your data. This
should place the same data on all selected sheets.
3) Right click on the sheet tab and select "Ungroup Sheets".

--
XL2002
Regards

William

(e-mail address removed)

| I'm a computer dumb-cluck so everybody knows the answer to this but I
| don't and I didn't find it on Google.
|
| I have a workbook with 100 worksheets. I want to enter a number in
| cell A1 of the first worksheet and have it appear in cell A1 of all
| the other sheets. But I don't want to have to link each of the 99
| sheets one-by-one.
|
| So how do I in Excel 97?
|
| Thank you
|
 
Back
Top