3d worksheets simoultaneously changing information in both

[SJ Hinton]

I have designed a 3D worksheet and will need to insert blocks of information to both (or delete) and want both worksheets to update in the same area of both sheets simoultaneously. How do I do this?

 

[Marie]

Quick way: if you select both worksheets at the same time
(while pressing CTRL key click on desired worksheet tabs)
then begin modifying a particular range, you should get
identical results in both worksheets.

But be sure to deselect the group worksheet selection when
finished if you want to make changes to only a single
worksheet.

-----Original Message-----
I have designed a 3D worksheet and will need to insert

blocks of information to both (or delete) and want both
worksheets to update in the same area of both sheets
simoultaneously. How do I do this?

 

[Gord Dibben]

You could link sheet2 to sheet1 by formula so sheet2 updates when sheet1 is
updated.

=sheet1!A1 entered in sheet2 will link back to sheet1.

Alternative........

Select all sheets to "group" them and any changes made on one sheet will be
done to all in the group. This is especially good for entering constants and
doing formatting.

To group sheets....right-click on a sheet tab and "select all" or select
first sheet then shift-click on last sheet to group all. CRTL + Click on
non-contiguous sheets to select just these.

DO NOT FORGET to ungroup when done. Disaster lurks on grouped sheets.
Right-click and "ungroup sheets"

Gord Dibben Excel MVP

On Mon, 19 Jul 2004 14:46:01 -0700, SJ Hinton <SJ