Linking or grouping sheets in Excel

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I need to link together multiple sheets in a workbook so
that if I enter a new row on Sheet 1 at A5 it will enter
a new row on all the other sheet in this work book. I
know that in Q-Pro to do this make a group and then go to
view and turn on group mode, but I can't find this
function in Excel. Any help with this would be greatly
appreciated.
Thanks
Pam
 
Hi
try
- select your row on the first sheet
- hold down the SHIFT key and select with your mouse all worksheets
- insert your row
 
To group sheets (i) click the first sheet tab (ii) hold down Shift and click
the last sheet tab.

Rgds,
Andy
 
Pam

Select first worksheet then right-click on tab and "select all sheets" to
group them.

Use SHIFT + Click to select contiguous sheets.

Use CRTL + Click to select non-contiguous sheets.

DO NOT FORGET to right-clcik and "ungroup" after you have inserted the row or
done whatever.

What is done to one sheet in the group will be done to all, leading to some
nasty surprises if "grouping" is forgotten.

Gord Dibben Excel MVP
 
Back
Top