Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to list all worksheets and switch sheets with shortcuts in Excel?

When you are handling lots of worksheets in Excel, It will be better for you to handle lots of worksheets / sheets in Excel when you have a big computer screen. But that's the most convenience way for you. The best solution will be you can list as many worksheets as you want in Excel. And that's why we are going to instroduce how to list all worksheets and switch sheets easily in Excel.

List all worksheets and manage them with Kutools for Excel

Switch worksheets with shortcuts in Excel

Switch between just two worksheets back and forth with Kutools for Excel

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial

arrow blue right bubble List all worksheets and manage them with Kutools for Excel

In Excel, all the sheet tabs will be listed at the bottom of the Excel window. But if you handle lots of sheets in a workbook, I am afraid that the sheet tabs bar will become too short to display all the sheet tabs, so you may have to use the sheet tabs scrolling buttons for switching between sheets in Excel.  In this case, I recommend you Kutools for Excel's Navigation Pane which can help you deal with many sheets at once in Excel.

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

It is much easier to list worksheets in Excel with Kutools for Excel installed, if you are using a number of worksheets in one workbook. Kutools for Excel just provides a workbook/worksheet list called Navigation Pane, which better list the worksheets in excel vertically into one group at the left panel side. The below instruction shows you how to list worksheets in excel workbook.

Click Kutools > Navigation Pane. See screenshot:

You will have a Navigation Pane as shown in the below screenshot:

Note: You can easily switch between workbooks in the Workbook pane, easily switch between worksheets in the Worksheet pane. Also, you can unhide all the hidden sheets by clicking, and click this button again will hide all the hidden sheets at once.

arrow blue right bubble Switch worksheets with shortcuts in Excel

If there are multiple sheets in a workbook, and you want to switch between sheets on the sheet tabs bar from left to right or right to left with shortcuts, you can get it done as follows in Excel.

Ctrl + PgUp: Swicth the sheets from right to left, sheet 2 to sheet 1.

Ctrl + PgDn: Move the sheets from left to right, sheet 1 to sheet 2.

The shortcuts in Excel just can switch between the sheets which adjacent each other. If you want to stick to switch between just two sheets which are not adjacent, for example, sheet 2 and sheet 12, Kutools for Excel can get this done for you easily.

Switch between just two worksheets back and forth with Kutools for Excel

With Kutools for Excel installed, you can quickly stick to switch between just two sheets back and forth with or Win+A shortcuts.

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

Step 1. Click Kutools > Navigation > Sheet.

Step 2. In the Worksheets pane, click sheet 2 first and then click sheet 12 that you want to switch between, see screenshot:

Step 3. After that, you can click to switch between sheet 2 and sheet 12 or press Win + A shortcuts to just switch between them.

With Navigation Pane feature of Kutools for Excel you also can list all columns and range names of all open workbooks in the pane. For more information about this utility, please visit Navigation Pane.

Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 80% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Aramat · 4 years ago
    How do I revers this this?
    I have a list of fifty different names I need to enter on the tabs of 50 worksheets (all on the same workbook). Is there a macros formula I can use to accomplish this? I'm trying to not manually enter 50 names on tabs/worksheets.
    I know how to get the tab names to form a list on a separate sheet, how do I reverse that?
    Thank you