Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 40,727 times.
Learn more...
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 How.com.vn 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.
Steps
Open your project in Excel. 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.
Press and hold Ctrl (Windows) or ⌘ Cmd (Mac). You'll find this key on your keyboard next to the space bar. Keep this key pressed down until otherwise instructed.Advertisement
Press ⇟ PgDn (tab right) or ⇞ PgUp (tab left). As long as you have the Ctrl or Cmd key pressed, you can use PgDn and PgUp to cycle through your spreadsheet's tabs.
Release Ctrl (Windows) or ⌘ Cmd (Mac) when you are done cycling through the tabs. 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.
Open your project in Excel. 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.
Press F5. 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.
Type the sheet's name that you want to go to. If you did not rename your sheets, the names are generally "Sheet 1/2/3".- For example, type Sheet3 to navigate to that sheet.
Type an exclamation mark (!). 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!.
Type the cell you want to go to. 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.
- 6Press ↵ Enter (Windows) or ⏎ Return (Mac). The black outline that indicates which box is selected will go to your entered sheet and cell.
Expert Q&A
Tips
About This Article
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).
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
