Why Excel for the Web Cannot Select Multiple Worksheets & Solutions
Question details
Users are unable to select or group multiple worksheet tabs simultaneously in the web or Microsoft Teams versions of Excel.
- Product
- Excel for the Web
- Device & OS
- not provided
- Scenario
- Attempting to manage, edit, format, or print multiple worksheets at once while working in a browser or Microsoft Teams.
- Observed behavior
- Pressing Ctrl-click or Shift-click on worksheet tabs does not select multiple sheets, which differs from the functionality available in the desktop application.
Verify whether you are working in a web browser, Microsoft Teams, or a desktop application, as advanced worksheet management features vary significantly across these platforms.
Open the Workbook in the Desktop Application
To perform actions on multiple worksheets simultaneously, you must switch from the web interface to a fully featured desktop application.
Excel for the web is designed as a lightweight tool for quick edits. It intentionally restricts certain advanced actions, including grouping or selecting multiple sheets via keyboard shortcuts. Switching to the desktop app restores this functionality.
In Excel for the web, look at the top ribbon menu and click on the 'Viewing' or 'Editing' button.
Choose the 'Open in Desktop App' option from the dropdown menu to launch the file locally.
Once the file opens in your desktop spreadsheet software, hold the 'Ctrl' key and click on the specific tabs you want to select, or hold 'Shift' to select a continuous range of sheets.
Use the All Sheets Menu for Navigation
If your goal is simply to jump between different sheets quickly rather than editing them simultaneously, use the built-in web navigation tools.
Group and Edit Multiple Worksheets Easily with WPS Office
Since web-based spreadsheet tools often lack advanced tab management, consider switching to WPS Office. It provides a robust, lightweight desktop experience with full support for multi-sheet selection, editing, and formatting, without the premium price tag.
- 1. Download and install: Get WPS Office for free from the official website and install it on your computer.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your .xlsx workbook.
- 3. Select multiple tabs: Hold down the Ctrl key and click multiple worksheet tabs at the bottom of the screen to group them and apply changes simultaneously.
Frequently Asked Questions
Can I delete multiple sheets at once in Excel for the Web?
No. Because Excel for the web does not support selecting multiple sheets, you must delete sheets one by one. To delete them in bulk, you need to open the file in a desktop spreadsheet application.
Does this limitation apply to Excel in Microsoft Teams?
Yes. Opening an Excel file directly within Microsoft Teams uses the same web-based engine as Excel for the web, meaning you will face the same inability to Ctrl-click or Shift-click multiple worksheet tabs.
Will multi-sheet selection be added to Excel for the web?
While web applications are continuously updated, multi-sheet selection currently remains a desktop-only feature due to browser interface limitations and performance optimizations.
