How to Move Between Tabs in Excel: Windows & Mac

PDF download Download Article
Easily tab between worksheets in Excel for Windows & Mac
PDF download Download Article

Do you want an easier way to switch between tabs in your Excel workbook? If you have multiple tabs, also called worksheets, in your Excel document, navigating through them can be confusing. This wikiHow article will show you easy ways to move between tabs in Microsoft Excel using simple keyboard shortcuts and the "Go To" command.

Swapping Tabs in Excel

  • PC: Press Ctrl + PgDn to tab right, or Ctrl + PgUp to tab left.
  • Mac: Press Cmd + PgDn to tab right, or Ctrl + PgUp to tab left.
  • You can also press Ctrl + G (PC) or Cmd + G (Mac) to use GoTo to switch to tabs by name.
Method 1
Method 1 of 3:

Using Keyboard Shortcuts

PDF download Download Article
  1. You can open your project within Excel by clicking Open from the File tab, or you can right-click on the file in a file browser and click Open With and Excel .
    • You can use this method with both Windows and Mac computers.
  2. You'll find this key on your keyboard next to the space bar. Keep this key pressed down until otherwise instructed.
    Advertisement
  3. As long as you have the Ctrl or Option key pressed, you can use PgDn and PgUp to cycle through your spreadsheet's tabs.
    • If this doesn't work, or if you have a laptop, try pressing and holding the Fn key along with Ctrl / Option , and then pressing PgDn or PgUp .
    • On a MacBook with no PgDn or PgUp keys, use Option + the right or left arrow key to move between sheets.
  4. Only after you are done navigating through the tabs should you release the Ctrl or Option key. If you continue pressing PgDn or PgUp , you'll most likely end up at the top or bottom of the spreadsheet instead of cycling through tabs.
  5. 5
    Use other keyboard shortcuts (optional). Excel has a few other available keyboard shortcuts to use that function a little differently.
    • To move to a different tab without loading unused ones: Press F6 and use the right/left arrow key to select the sheet. Press Enter/Return to open the tab.
    • To quickly navigate to the last tab of a workbook: Hold Ctrl and left-click the small arrow next to the sheet tabs. Then, click the last tab.
    6. Advertisement
Method 2
Method 2 of 3:

Using Go To

PDF download Download Article
  1. You can open your project within Excel by clicking Open from the File tab, or you can right-click on the file in a file browser and click Open With and Excel .
    • You can use this method with both Windows and Mac computers.
  2. You'll see the F numbers above the row of numbers on your keyboard. A "Go To" window will open.
    • You can also press Ctrl + G on Windows to pull up the "Go To" window. You can also go to Home > Find & Select > Go To from the menu. [1]
    • On some keyboards, you may have to press the Fn key at the same time as F5 .
  3. If you did not rename your sheets, the names are generally "Sheet 1/2/3".
    • For example, type Sheet3 to navigate to that sheet.
  4. ). Spaces aren't allowed in the "Go To" feature, so you'll need to use an exclamation mark.
    • For example, type Sheet3! .
  5. If you don't have a specific cell in mind, enter A1 to go to the top of the sheet.
    • For example, enter Sheet3!A1 in the "Go To" window.
  6. The dark green outline that indicates which box is selected will go to your entered sheet and cell.
    • You can also click OK in the Go To window.
    7. Advertisement
Method 3
Method 3 of 3:

Troubleshooting

PDF download Download Article
  1. 1
    The keyboard shortcut doesn't work. If pressing Ctrl / Option + PgDn/PgUp doesn't work, you may need to press the Fn key first. This is more likely if you're using a laptop.
    • First, press Ctrl / Option + Fn . Then, press PgDn or PgUp to navigate between tabs.
    • If your keyboard doesn’t have a PgDn or PgUp key, you may need to use the right or left arrow keys instead.
  2. 2
    Is there a faster way to switch tabs? If you have a lot of tabs and you want to skip to the last tab, press Ctrl and left click the arrow next to the tab. You can then click the last tab.
  3. 3
    How do I view two tabs side-by-side? To look at two separate tabs together, you can use a built-in feature within Excel. Do the following:
    • Click the View tab at the top.
    • Click New Window in the Window group.
    • Click View Side by Side .
    • Select the tab you want to view in each window.
    • Click Synchronous Scrolling to scroll both tabs at the same time.
    4. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      The Best Ways to Make & Format Lists in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Create a Pie Chart in Microsoft Excel
      How to
      Create a Chart in Microsoft Excel: Step-by-Step Guide
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Change a Comma to Dot in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Create a Mortgage Calculator With Microsoft Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/find-and-select-cells-that-meet-specific-conditions-in-excel-2d686424-6150-4015-a8e4-a5990f4d7e3a

      About This Article

      Article Summary X

      1. Open your project in Excel.
      2. Press and hold Ctrl (Windows) or Cmd (Mac).
      3. Press PgDn (tab right) or PgUp (tab left).
      4. Release Ctrl (Windows) or Cmd (Mac).

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 68,492 times.

      Is this article up to date?

      Advertisement