Others

How to Jump Across Multiple Worksheets in Excel Workbook

Bushra Parveen Oct 19, 2026 868 views

Question details

The user needs a fast way to jump forward or backward by several sheets in an Excel workbook containing over 100 worksheets without repeatedly clicking the navigation arrows.

How to Jump Across Multiple Worksheets in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Navigating through a large workbook with numerous worksheets.
Observed behavior: The user wants to navigate by jumping 5, 10, or more sheets at once instead of clicking through tabs one by one.

Before you start

Before writing VBA macros to jump between sheets, check if your workbook contains hidden sheets, as index-based macro calculations might inadvertently skip them or cause sudden script errors.

Solution 1Recommended

Use the Worksheet List Menu

The fastest and easiest way to jump directly to any specific sheet in a large workbook without using code.

Locate the navigation arrows

Look at the bottom-left corner of the Excel window, just to the left of your horizontal sheet tabs. You will see left and right navigation arrows.

Open the full sheet list

Right-click anywhere on these navigation arrows. This action will open a dialog box or a context menu displaying a list of all the worksheets in your workbook.

Jump to your desired sheet

Scroll through the list, select the name of the worksheet you want to jump to, and click OK. Excel will instantly activate that worksheet.

Instant Navigation: This built-in feature is highly recommended for workbooks with more than 20 worksheets, as it completely eliminates the need for sequential clicking.

Solution 2

Navigate Sequentially with Keyboard Shortcuts

Ideal for moving forward or backward by just a few adjacent sheets very quickly.

Solution 3

Use a VBA Macro for Specific Jumps

Best for users who repeatedly need to jump exactly 5, 10, or a customized number of sheets forward or backward.

Manage Spreadsheets Efficiently

Navigate Large Workbooks Effortlessly in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools for handling files with over 100 worksheets smoothly. Its robust tab management and seamless interface make navigating, analyzing, and organizing large data sets a breeze.

1. Open your large file in WPS Spreadsheet: Launch WPS Office and open your workbook containing multiple sheets.
2. Access the sheet navigation list: Look to the bottom-left corner of the window and right-click the sheet navigation controls.
3. Select your destination sheet: Scroll through the pop-up list and click your target sheet to jump across multiple tabs instantly.

Jump to any worksheet instantly using the built-in sheet list manager.100% compatible with Microsoft Excel (.xlsx and .xls) formats.Lightweight application with blazing-fast load times for large files.Familiar tabbed interface that requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

How can I quickly jump to the first or last worksheet in Excel?

You can hold down the Ctrl key and left-click the left or right navigation arrow in the bottom-left corner of the Excel window. This action bypasses all middle sheets and jumps you immediately to the very first or very last worksheet.

Can I create a clickable link to jump to a specific worksheet?

Yes. Select a cell on your current sheet, go to the Insert tab, and click Hyperlink (or Link). Choose 'Place in This Document' from the left pane, then select the specific worksheet you want to link to. Clicking that cell will instantly jump to the selected sheet.

Will the VBA macro return an error if I try to jump past the last sheet?

Yes, if your VBA jump value (e.g., +10) exceeds the total remaining number of worksheets, the macro will fail. It is highly recommended to add an error-handling statement like 'On Error Resume Next' at the beginning of your VBA code to prevent application crashes.

Office Quick Solutions