General discussion

Locked

Group Worksheets in Excel

By schinny1 ·
Recently, I converted the entire office to Office 97. Previously we had Lotus 1-2-3. In Lotus, you can group Worksheets so when you were on Sheet1 Cell A97, when you switch to Sheet 17, you would go directly to Cell A97. Is this possible in Excel???? HELP!

Thanks,
Steve

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Group Worksheets in Excel

by DKlippert In reply to Group Worksheets in Excel

Hold down the Ctrl key (to select individual tabs) or Shift (to select a contiguous range of tabs) and click on the desired Sheet tabs. This will group them so that actions taken on one sheet will be duplicated at the same location on all selected sheets.

Collapse -

Group Worksheets in Excel

by schinny1 In reply to Group Worksheets in Excel

The question was auto-closed by TechRepublic

Collapse -

Group Worksheets in Excel

by Vagab0nd In reply to Group Worksheets in Excel

When you select multiple sheets in Excel and do something with cell or range on one of them - you automatically do it on all of them - so you don't need to 'switch' to that cell - you are already there

Collapse -

Group Worksheets in Excel

by schinny1 In reply to Group Worksheets in Excel

The question was auto-closed by TechRepublic

Collapse -

Group Worksheets in Excel

by schinny1 In reply to Group Worksheets in Excel

This question was auto closed due to inactivity

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums