Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In this question, he was asking about keyboard shortcut to switch tabs. But this shortcut moves the sheet backward or forward, which means that pressing Ctrl+PageUp on the last sheet doesn't move the first sheet.

Is there any shortcut which allows circular switching (like Ctrl-Tab in Windows)?

share|improve this question
You could write your own macro to do this and assign it to something like Ctrl+Shift+PageUp (or any other key combination that works for you) – jonsca Aug 18 '11 at 12:45
up vote 4 down vote accepted

This is a simple version of what I described in the comment.

Sub SwitchSheets()
    Dim NextSheet As Worksheet
    Set NextSheet = ActiveSheet.Next
    If NextSheet Is Nothing Then
    End If
End Sub

From the View tab click on Macros, select SwitchSheets, go to Options and set a shortcut key for it (holding down Shift as needed, to add that into the chord).

share|improve this answer

Your Answer


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.