Excel.Tips.Net ExcelTips (Menu Interface)

Shortcut to Move between Two Worksheets

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Shortcut to Move between Two Worksheets.

You can easily move between worksheets in a workbook by using Ctrl+Pg Up and Ctrl+Pg Down. What if you want to use a shortcut to move between two specific, non-neighboring worksheets, such as Sheet1 and Sheet4? In this case, it is best to use a macro to do the jumping around.

If desired, you could define two macros that would do the jumping. One macro would jump to Sheet1 and the other to Sheet4. These would be easy enough to create using the macro recorder, and you could assign a shortcut key to each of the macros.

If you are looking for a single shortcut that will toggle between the two worksheets, then you can use a macro such as this:

Sub JumpBetween1()
    If ActiveSheet.Name = "Sheet1" Then
    End If
End Sub

The macro simply checks to see which worksheet is currently displayed. If it is Sheet1, then Sheet4 is displayed. In all other instances, Sheet1 is displayed. This is handy, but it means that if you currently have Sheet2 displayed, the shortcut will always display Sheet1. You might not want the macro to do anything unless either Sheet1 or Sheet4 is displayed. In that case, you should use this variation of the macro:

Sub JumpBetween2()
    If ActiveSheet.Name = "Sheet1" Then
    ElseIf ActiveSheet.Name = "Sheet4" Then
    End If
End Sub

Note that the only difference between the two macros is that the latter variation uses ElseIf to check if Sheet4 is displayed. This means that if any worksheets other than Sheet1 or Sheet4 is displayed, the macro will do nothing.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3216) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Shortcut to Move between Two Worksheets.

Related Tips:

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!


Leave your own comment:

  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*What is 4+5 (To prevent automated submissions and spam.)
          Commenting Terms

Comments for this tip:

Scott Renz    08 Jun 2015, 12:46
Thanks, Allen, I did not know about using Ctrl+Pg Up and Ctrl+Pg Down. I had been using the mouse to go to the next sheet--which becomes difficult once I get to the last tab showing on the screen.
Willy Vanhaelen    07 Jun 2015, 12:15
@Ray Austin

In my comment of 26 Jan 2015 on Excel tip
I posted a macro that creates a list of all the sheets with a hyperlink to them.
MWilson    06 Jun 2015, 20:57

There are a couple of ExcelTips that address your question:



But what I do for really big xls files with many worksheets is to create a table of contents in worksheet tab #1. There I list all of the worksheet tab names in one column, and create a hyperlink to each in the next column. (You can sort those names/links any way that is best for you).

Now whenever I want to jump to a worksheet I go to that first tab and click on the hyperlink.

Ray Austin    06 Jun 2015, 07:06
I typically move around between 4 or 5 worksheets in a workbooks having 40+ sheets.
Is it practicable to have a routine similar to the "Go To" Cmd and reveals the full alphabetical worksheet list on the screen, then allows you to select with 1 click please ?
Thank you

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2015 Sharon Parq Associates, Inc.