How to Jump to a Specific Sheet Tab in Google Sheets

Published on

Using the Go to range search feature, we can quickly jump to a specific sheet tab in Google Sheets.

If your file contains a large number of tabs and you can remember the tab names, this method is much faster than you might think.

In this post, besides showing how to use Go to range to jump to a specific sheet tab in Google Sheets, I’ll also shed some light on the different search features (or search fields) available within Google Sheets.

Four Different Search Fields in Google Sheets

I’ve found four main search fields available in Google Sheets:

  1. Find (Ctrl + F on Windows, ⌘ + F on Mac)
  2. Search the menus (Alt + / on Windows, Option + / on Mac)
  3. Search links (Ctrl + K on Windows, ⌘ + K on Mac)
  4. Go to range

Besides these, there are other search fields embedded within filters, slicers, pivot tables, and more. But for the purpose of this post, we’ll focus on the main four—especially Go to range, which lets you quickly jump to a specific sheet tab in Google Sheets.

Before diving into the details of Go to range, let me briefly explain the other three search features.

1. Find (Find and Replace)

As expected, the Find feature lets you search within a sheet.

Just type what you’re looking for in the small search field that appears in the top-right corner. Google Sheets will highlight the matching cells and show the number of matches, e.g., “1 of 4”.

Tip: Keep the Find field open and switch to a different sheet tab to continue searching there.

Find – Search within a sheet in Google Sheets

Find and Replace is a more advanced version of Find, accessible via Edit > Find and Replace, or with shortcuts:

  • Windows: Ctrl + H
  • Mac: ⌘ + Shift + H

While it’s not directly related to jumping between sheet tabs, it’s still a search feature—just like Go to range.

2. Search the Menus

One of the fastest ways to find a command, function, or formatting option is using Search the menus.

Use the shortcut (Alt + / on Windows or Option + / on Mac), or access it via the Help menu.

This feature is actually what we’ll use to access the Go to range function, so it plays a key role in helping you jump to a specific sheet tab in Google Sheets.

Example: Instead of manually navigating to Format > Number > Custom number format, you can hit Alt + /, type “custom,” and click on Custom number format when it appears.

Search the Menus – Find functions, formats, commands, and more in Google Sheets

3. Search Links in Google Sheets

This feature lets you search and insert a hyperlink to a web page or another sheet within your file. You can also paste custom links manually.

Steps:

  • Open the Insert link box (via Insert > Link, or use the shortcut: Ctrl + K on Windows / ⌘ + K on Mac)
  • Type your search term into the link field
  • You’ll see suggestions from both your spreadsheet and the web
  • You can also paste your custom link directly into this field
Insert Link – Search web links and sheet references within Google Sheets

Although this isn’t directly related to navigating between sheet tabs, it’s still a useful search field to know.

But there’s a workaround to jump to a specific sheet tab using this:

  • At the bottom of the Insert Link dialog box, click on “Sheets and named ranges”
  • Click on the sheet name you want to jump to
  • This will insert a hyperlink in the active cell
  • Click the hyperlink to jump to that specific sheet tab

It’s a handy feature—but not as fast or direct as using the Go to range method.

4. Go to Range — Jump to a Specific Sheet Tab in Google Sheets

Now, let’s focus on the core of this tutorial: how to jump to a specific sheet tab using the Go to range feature.

Let’s say you have a file with 20+ sheet tabs. If you can recall the name of a tab, there’s no need to scroll or build a hyperlink-based table of contents. You can jump straight to that tab!

Here’s how.

How to Access the Go to Range Search Field

The Go to range feature isn’t directly listed in any menu, nor does it have a default shortcut. But it can be accessed using Search the menus.

Steps:

  1. Go to the Help menu
  2. In the search bar, type “Go”
  3. Click on Go to range when it appears — and voilà! The hidden search field opens.

You can use this field to jump to a cell, a named range, or even a sheet tab—just type the sheet name and press Enter.

Go to Range – Jump to a specific sheet tab in Google Sheets using the hidden search field

Steps to Jump to a Specific Sheet Tab in Google Sheets

Let’s say you want to jump to a sheet named April. Here’s how:

  1. Go to the Help menu and search for “Go”
  2. Select Go to range
  3. Type April and hit Enter

That’s it! You’ll instantly be taken to the April sheet tab.

Bonus: Enable a Shortcut for Go to Range

Want to make it even faster?

You can assign the shortcut F5 to open the Go to range box—but only after enabling compatible keyboard shortcuts.

To do that:

  1. Go to Help > Keyboard shortcuts
  2. Enable “Enable compatible spreadsheet shortcuts”

Now you can simply:

  • Press F5
  • Type the sheet name
  • Hit Enter

It’s one of the quickest ways to jump to a specific sheet tab in Google Sheets.

Final Thoughts

Jumping to a specific sheet tab in Google Sheets doesn’t need to involve hyperlinks, scrolling, or manual tab switching.

With the Go to range feature—and optionally enabling the F5 shortcut—you can easily navigate large spreadsheets with dozens of tabs in just seconds.

Try it out and enjoy a smoother Google Sheets experience!

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Expert Prashanth KV is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.

Top Discussions

More like this

Pivot Table Formatting, Output & Special Behavior in Google Sheets

Pivot Tables in Google Sheets are powerful—but they can get tricky once you move...

Pivot Table Calculations & Advanced Metrics in Google Sheets

When it comes to built-in tools for data analysis and visualization in Google Sheets,...

Google Sheets Pivot Table Tutorial: Basics, Setup, and Date Grouping

The easiest way to summarize, analyze, and report data in Google Sheets is by...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.