How to Move Between Tabs in Excel: Windows & Mac

PDF download Download Article
Easily tab between worksheet 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.

Things You Should Know

  • 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 2:

Using Keyboard Shortcuts

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d0\/Move-Between-Tabs-in-Excel-Step-1.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-1.jpg","bigUrl":"\/images\/thumb\/d\/d0\/Move-Between-Tabs-in-Excel-Step-1.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-1.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f7\/Move-Between-Tabs-in-Excel-Step-2.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-2.jpg","bigUrl":"\/images\/thumb\/f\/f7\/Move-Between-Tabs-in-Excel-Step-2.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll find this key on your keyboard next to the space bar. Keep this key pressed down until otherwise instructed.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/ff\/Move-Between-Tabs-in-Excel-Step-3.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-3.jpg","bigUrl":"\/images\/thumb\/f\/ff\/Move-Between-Tabs-in-Excel-Step-3.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    As long as you have the Ctrl or Cmd key pressed, you can use PgDn and PgUp to cycle through your spreadsheet's tabs.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/58\/Move-Between-Tabs-in-Excel-Step-4.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-4.jpg","bigUrl":"\/images\/thumb\/5\/58\/Move-Between-Tabs-in-Excel-Step-4.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Only after you are done navigating through the tabs should you release the Ctrl or Cmd 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. Advertisement
Method 2
Method 2 of 2:

Using Go To

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e4\/Move-Between-Tabs-in-Excel-Step-5.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-5.jpg","bigUrl":"\/images\/thumb\/e\/e4\/Move-Between-Tabs-in-Excel-Step-5.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-5.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/be\/Move-Between-Tabs-in-Excel-Step-6.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-6.jpg","bigUrl":"\/images\/thumb\/b\/be\/Move-Between-Tabs-in-Excel-Step-6.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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 (Windows) or Cmd + G (Mac) to pull up the "Go To" window. You can also go to Edit > Find > Go To from the menu.
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/94\/Move-Between-Tabs-in-Excel-Step-7.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/9\/94\/Move-Between-Tabs-in-Excel-Step-7.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4e\/Move-Between-Tabs-in-Excel-Step-8.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/4\/4e\/Move-Between-Tabs-in-Excel-Step-8.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    ). Spaces aren't allowed in the "Go To" feature, so you'll need to use an exclamation mark.
    • For example, you should have typed Sheet3! .
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0b\/Move-Between-Tabs-in-Excel-Step-9.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/0\/0b\/Move-Between-Tabs-in-Excel-Step-9.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you don't have a specific cell in mind, enter A1 to go to the top of the sheet.
    • For example, you should have entered Sheet3!A1 in the "Go To" window.
  6. 6
    Press ↵ Enter (Windows) or ⏎ Return (Mac). The black outline that indicates which box is selected will go to your entered sheet and cell.
    7. Advertisement
{"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Move-Between-Tabs-in-Excel-Step-10.jpg\/v4-460px-Move-Between-Tabs-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Move-Between-Tabs-in-Excel-Step-10.jpg\/v4-728px-Move-Between-Tabs-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}



Expert Q&A

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

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Combine Columns in Excel Without Losing Data
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      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 45,217 times.

      Is this article up to date?

      Advertisement