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.


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.

| improve this answer | |
  • @ 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 '12 at 7:18
  • @frog, not that I'm aware of, sorry. – Mike Fitzpatrick Dec 19 '12 at 11:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.