Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 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.

share|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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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