1

How do you set focus on sheet tab in excel working book?I need to do a number of functions such as select all sheets, switch back and forth the sheet, delete, group,ungroup, is very inconvenient to use mouseclick.

1 Answer 1

1

On Windows versions of Excel you can use Ctrl + Page Up/Page Down to move between worksheets and holding down Shift while doing so will allow you to select multiple (adjacent) worksheets.

2
  • @ Mike Fitzpatrick that's very helpful Mike! Can I dare myself ask a related questions, is there a shortcut to ungroup the sheets grouped already and select all(instead of multiple) the sheets in one go with keyboard shortcuts?Tks!
    – frog
    Dec 19, 2012 at 7:18
  • @frog, not that I'm aware of, sorry. Dec 19, 2012 at 11:02

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .