Windows Forum

Ask something
Discussion Locked

Group Worksheets in Excel

0 helpful
5 replies

by schinny1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

by dklippert

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.

by vagab0nd

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

This discussion is closed to new replies.