editing worksheets / old lotus trick help

[Loricav]

I have a workbook with many sheets and I want to add info into the firs
sheet and have excel automatically add it to the others. I thought i
did this but I must be thinking of the old lotus days when if yo
marked the sheets as grouped and it automatically did everything fo
you. Please help me I have a project that could be a nightmare if
can't figure this out.

Thanks for any help you can give

 

[Frank Kabel]

Hi
try the following
- select the cell
- hold down the SHIFT key and select the other sheets
- enter your data

 

[Charlie]

You can do this with Excel also.

Right click on the tab for the first worksheet,
choose 'Select all Sheets'. Now anything entered
(including formats) will appear on all worksheets.

Charlie O'Neill

 

[Harlan Grove]

I have a workbook with many sheets and I want to add info into the first
sheet and have excel automatically add it to the others. I thought it
did this but I must be thinking of the old lotus days when if you
marked the sheets as grouped and it automatically did everything for

...

FWIW, 123's group mode allowed one to make common *formatting* changes to all
grouped sheets at once but not data entry, which was always one cell in one
sheet at a time.

 

[Loricav]

Thank you all so much for your help. You saved the day. I reall
appreciate that you take the time to answer these questions.

Take Care
Lor