How to Fix Multiple Range Selection Error on Right-Click in Excel
Question details
User experiences repeated error prompts when right-clicking a multiple-range selection and hovering over the Search option.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Right-clicking to access the context menu after selecting multiple ranges in a spreadsheet.
- Observed behavior
- An error message pops up repeatedly stating the operation cannot be performed on a multiple range selection, specifically triggered when hovering over the Bing Search option in the context menu.
Verify your exact Microsoft Excel build version by navigating to File > Account. This specific context menu error is a known bug tied primarily to certain Excel 2109 Insider, Preview, or Beta builds.
Switch to Current Channel and Update Office
Moving away from preview or beta builds to the stable Current Channel resolves this known context menu bug.
Microsoft identified this issue in specific beta and preview builds of Excel 2109. Reverting to a stable public release or updating to a patched version fixes the multiple-range selection conflict with the Bing Search option.
Launch Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left sidebar.
Locate the 'Office Insider' section. Click to manage your settings and switch your channel from 'Beta Channel' or 'Preview' to the stable 'Current Channel'.
Click on 'Update Options' next to Office Updates and select 'Update Now' to download and install the latest stable release.
Use Keyboard Shortcuts as a Temporary Workaround
If you must stay on your current preview build, avoid right-clicking the multiple selection entirely.
Avoid Excel Build Bugs by Switching to WPS Office
Since this multiple-range selection error is a known bug in specific Microsoft Excel preview builds, consider switching to WPS Office. It provides a highly stable, lightweight, and free spreadsheet experience with full compatibility for your existing Excel files.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
- 2. Install and Launch: Follow the simple installation prompts, then open WPS Spreadsheet.
- 3. Open Your Files: Open your existing .xlsx files directly and enjoy stable, error-free multiple-range selections.
Frequently Asked Questions
Why does the Search context menu option cause an error?
In certain Excel preview and beta builds (like 2109), hovering over the Search option in the context menu incorrectly triggers an unsupported command check on multiple range selections, resulting in the repeated error prompt.
Can I disable Bing Search in Excel to stop this error?
You can try disabling connected experiences by navigating to File > Options > Trust Center > Trust Center Settings > Privacy Options > Privacy Settings and unchecking optional connected experiences, though updating your Office build is the most permanent fix.
Does this error affect single cell selections?
No, this specific bug only occurs when you have selected multiple non-adjacent ranges (typically by holding the Ctrl key) and right-click to open the context menu.
