A desktop monitor displays a spreadsheet with charts, navigation panels, and callouts illustrating worksheet features.
Big Excel workbooks tend to turn into digital filing cabinets with no labels. Most people cope by scrolling, squinting at tab names and hoping. How-To Geek's Tony Phillips lays out six navigation habits that replace that routine. Here they are with the practical detail you need, plus Microsoft's documentation where it exists and a few cautions about version differences.

A desktop monitor displays a spreadsheet with charts, navigation panels, and callouts illustrating worksheet features. 1. Get to a distant sheet without clicking through tabs​

Right-click the sheet arrows. When a workbook has more tabs than fit along the bottom of the window, right-click either of the two small navigation arrows in the bottom-left corner. A list of sheets appears, and you can pick one directly. Phillips says to double-click the sheet you want. A Microsoft Community Hub thread gives the same answer for a user whose three-dot button wasn't showing the sheet list. The reply from an Excel MVP-style contributor was simply to right-click the arrows. That is a community answer, not a formal support article.

Use the keyboard for neighbours. Ctrl+Page Up and Ctrl+Page Down step to the previous or next sheet. They work for adjacent sheets, but the problem is a sheet several tabs away.

Open a second window. Phillips suggests View > New Window, which opens a second window of the same workbook so you can show a different worksheet in each. He says Alt+Tab flips between them and that changes made in one appear in the other. Microsoft's own guidance for this feature is framed around comparing sheets. You use New Window, then View Side by Side or Arrange All, and click the sheet you want in each window. That documented workflow is aimed at desktop Excel. Treat Alt+Tab as a handy Windows habit rather than an Excel feature.

2. Use the Navigation pane (Microsoft 365)​

Select View > Navigation, and the pane opens on the right side of the window. Each sheet gets its own section, which shows the tables, charts, PivotTables and images on that sheet. If the element is on another sheet, focus switches to the correct sheet and element.

Some details are worth knowing:

  • Availability. Microsoft's support page lists Excel for Microsoft 365 (Windows and Mac). Other write-ups say it also appears in Excel 2021. Check your own build before telling a whole department to use it.
  • Status-bar shortcut. Right-click the status bar and add Sheet Number. Selecting the sheet count then opens the pane and shifts focus to the sheet you pick.
  • Editing from the pane. Charts and images can be renamed, deleted or hidden, while PivotTables can only be renamed. There are no right-click options for tables.
  • Search. Phillips highlights keyword search. Independent write-ups agree. Office Watch says a simple search narrows the listing to matching elements. One blogger notes that search works best when your tables and charts have consistent, descriptive names. Microsoft's support page, as retrieved, doesn't describe the search box.
  • Accessibility. Microsoft says the pane also helps people with visual impairments reach all parts of a workbook and can improve how screen readers interpret it.

3. Search the whole workbook with Find​

Press Ctrl+F and select Options. Change Within from Sheet to Workbook, type your term and click Find All. Microsoft documents this. Selecting a result in the list selects its cell in the workbook, and you can sort the results by clicking a column heading.

Settings that change what you get:

  • Look in. Choose Formulas, Values, Notes or Comments. Pick Values if you want what's displayed. Pick Formulas if you're hunting for a function or reference inside a formula.
  • Match entire cell contents. This avoids stray partial matches. A search for "Acme" won't also return "Acme Holdings Ltd".
  • Match case, and Search by rows or columns. These narrow things further.
  • Wildcards. Microsoft documents ?, * and ~ in search terms.

Phillips says the results list shows sheet name, cell address, cell name, value and formula. Microsoft's text confirms the list and the click-to-select behaviour. The exact columns can vary by version, so don't treat that list as guaranteed.

4. Jump with the Name Box and defined names​

The Name Box sits to the left of the formula bar.

  • Go to a cell. Type a reference such as J702 and press Enter.
  • Go to another sheet. Phillips says to type Summary!B15, or 'Summary Sheet'!B15 if the name contains spaces.
  • Make bookmarks. Select a cell, click the Name Box, type a name such as TotalRevenue and press Enter. Pick it later from the drop-down.
  • Follow the naming rules. Microsoft notes that names can't contain spaces and must begin with a letter.
  • Manage names in one place. Use Formulas > Name Manager. Microsoft's selection guide notes you can't edit or delete names from the Name Box itself. Name Manager is where Edit and Delete live.
  • Reach tables. Phillips says the drop-down lists tables, so meaningful table names pay off.

5. Use Go To as a breadcrumb trail​

F5 or Ctrl+G opens Go To. Type a reference and press Enter. Microsoft's guide also lets you pick a named range from the list. You can enter several references separated by commas, and the Special button selects things like formulas or visible cells only.

Phillips adds a trick from his own testing. The recent-reference list, he says, tracks where you were before jumping with Go To or the Name Box, with the latest location at the top. It even listed references to other open workbooks. After wandering, he reopens the dialog and double-clicks a recent entry to return. This is his observation. I found no Microsoft documentation spelling out the history rules, so test it in your own version before relying on it.

6. Hyperlink your sheets together​

This works well for summary and detail structures.

  1. Select the cell for the link.
  2. Press Ctrl+K.
  3. Choose Place in This Document.
  4. Pick a sheet and, optionally, a cell, or choose a defined name.
  5. Set the display text and confirm.

Microsoft's documentation describes these steps, including the defined-name option. Phillips notes that a defined name keeps working if the sheet is renamed. Add a return link on each detail sheet so users aren't stranded.

For formula-driven links, use HYPERLINK. Phillips's example is =HYPERLINK("#'Projects'!A1","Go to projects"). Microsoft documents the form with a leading # for in-workbook destinations. One maintenance note: if a link was created with HYPERLINK, Microsoft says you edit the formula to change its destination, not the Edit Hyperlink dialog.

Which trick for which job?​

SituationBest tool
Next or previous sheetCtrl+Page Up/Down
Distant sheet, you know its nameRight-click sheet arrows
You remember an object but not where it isNavigation pane
You know the value but not the sheetCtrl+F, Within: Workbook
You know the exact addressName Box or Go To
Shared reports and dashboardsHyperlinks, HYPERLINK

The caveats​

None of this requires add-ins, but versions differ. The Navigation pane needs a recent Microsoft 365 build. Excel for the web has its own shortcut quirks, and Microsoft notes that Ctrl+G Go To works there for jumping to a cell. Defined names can't be created in Excel for the web, only selected once made in desktop Excel. And naming discipline is the quiet hero of this whole list. Names, table names and chart names make the Navigation pane, Name Box and hyperlinks useful. "Table17" helps no one.

The original piece also mentions in passing that old formatting and unused content can slow a workbook's load time. That is a separate topic, and nothing here covers it.

 

References

  1. 6 Excel navigation tricks that save you from endless worksheet scrolling How-To Geek 2026-10-24T11:00:17+00:00
  2. Show list of sheets on excel file (3 dots not working) | Microsoft Community Hub techcommunity.microsoft.com
  3. Compare two or more worksheets at the same time | Microsoft Support support.microsoft.com