3d worksheets simoultaneously changing information in both

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
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?
 
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
 
Back
Top