How to Display a List of All Excel Worksheets in WPS Office Spreadsheets When Sheet Navigation Fails
Question details
The user needs the fastest way to open a complete list of worksheets in WPS Office Spreadsheets when the sheet navigation control only advances one tab at a time.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working in a large Excel workbook and needs to switch quickly between many worksheets.
- Observed behavior
- Clicking the three-dot sheet navigation control only moves to the next tab rather than showing the full worksheet list.
Open the workbook in WPS Office Spreadsheets and make sure the sheet tab bar is visible at the bottom of the window. You do not need to unhide or rearrange sheets before opening the worksheet list.
Right-Click the Sheet Navigation Arrows to Display Every Worksheet
Use this method when left-clicking the sheet navigation arrows or three-dot control only moves through the tab strip one sheet at a time.
The worksheet navigation arrows are designed to scroll the sheet tab bar. Their right-click menu exposes the full worksheet list, so you can jump directly to any visible sheet instead of moving through dozens of tabs.
Launch WPS Office Spreadsheets and open the Excel workbook that contains the worksheets you need to navigate.
Go to the bottom-left corner of the WPS Office Spreadsheets window, just to the left of the sheet tabs, and find the two small left and right worksheet-navigation arrows.
Right-click the left or right worksheet-navigation arrow. WPS Office Spreadsheets displays a list of all visible worksheets in the active workbook.
Click the target sheet name in the list, then choose OK or press Enter. WPS Office Spreadsheets jumps directly to that worksheet.
Display the Worksheet List in WPS Office Spreadsheets Without Scrolling Tabs
Use the built-in worksheet list in WPS Office Spreadsheets to locate any sheet instantly when the navigation arrows only move to the next tab.
- 1. Open the Excel workbook: Open the workbook in WPS Office Spreadsheets.
- 2. Find the navigation arrows: Go to the bottom-left corner of the workbook window and locate the two small sheet navigation arrows.
- 3. Right-click a navigation arrow: Right-click either arrow to open the worksheet list.
- 4. Choose the sheet: Select the worksheet you need and click OK or press Enter.
- 5. Confirm the active sheet: Verify that WPS Office Spreadsheets switches to the selected worksheet immediately.
Frequently Asked Questions
Why does the three-dot sheet navigation control only move to the next tab when I click it?
The three-dot control and navigation arrows are built to scroll the sheet tab bar. To show every worksheet at once, right-click either of the two small navigation arrows in the bottom-left corner of WPS Office Spreadsheets.
Where exactly are the worksheet navigation arrows in WPS Office Spreadsheets?
They are at the bottom-left corner of the workbook window, to the left of the sheet tabs. They appear as two small left and right arrow buttons.
Does the worksheet list show hidden sheets as well?
No, the right-click worksheet list normally shows visible sheets only. If you need a hidden sheet, right-click any visible sheet tab, choose Unhide, select the hidden sheet, and click OK.
What should I do if right-clicking the navigation arrows does not show the list?
Make sure you are right-clicking the small arrow buttons, not the three-dot control or a sheet tab. If the view is restricted, switch to Normal view from the View tab and try again.
