'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Action Will Not Work on Multiple Selections Error
Question details
The user is encountering an error stating that an action cannot be performed on multiple selections when attempting to paste data or create a worksheet.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Pasting data into cells or attempting to create a new worksheet.
- Observed behavior
- Excel displays a prompt preventing the action, claiming it will not work on multiple selections, even if only one table is present in the workbook.
Ensure you have saved all your open workbooks and note down the exact macOS and Excel version numbers you are currently using, as this helps narrow down compatibility issues.
Troubleshoot Software Conflicts and Clipboard Managers
Identify and disable third-party clipboard utilities or Excel add-ins that might be interfering with your copy and paste actions.
On macOS, clipboard management tools or outdated Excel add-ins can sometimes intercept copy-paste commands, causing Excel to misinterpret the clipboard data as multiple non-adjacent selections.
Click the Apple menu in the top-left corner of your screen and select 'Restart'. This clears out minor system glitches and resets the system clipboard.
If you are running a third-party clipboard manager (such as Paste, CopyClip, or Maccy), locate its icon in your Mac's menu bar and temporarily quit or disable the application.
Open the 'Terminal' application from your Mac's Utilities folder, type 'pbcopy < /dev/null', and press Return to completely empty the clipboard.
Open Excel, click on the 'Tools' menu at the top of your Mac screen, and select 'Excel Add-ins'. Uncheck all active add-ins and click 'OK', then try pasting again to see if the issue is resolved.
Avoid Excel Errors with WPS Office
If Microsoft Excel continues to display frustrating selection errors on your Mac, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling spreadsheets without the bloat of conflicting add-ins.
- 1. Download and Install: Visit the official WPS website, download the macOS installer, and drag the WPS Office icon into your Applications folder.
- 2. Open Your Spreadsheet: Launch WPS Office Spreadsheet, click 'Open', and select the file that was causing issues in Excel.
- 3. Edit Without Errors: Perform your copy, paste, and worksheet creation actions seamlessly without multiple-selection interruptions.
Frequently Asked Questions
Why does Excel think I have multiple selections?
This usually happens when there are hidden columns, merged cells in the target paste area, or when a third-party clipboard utility holds multiple data points simultaneously, confusing Excel's paste function.
How do I manually clear the clipboard on a Mac without using Terminal?
You can copy a single, blank space or a single letter from any text editor. This overrides whatever complex data or multiple selections were previously held in the system clipboard.
Can merged cells cause the 'multiple selections' error?
Yes. Attempting to paste a range of data into an area containing merged cells that don't match the copied data's exact size and shape often triggers selection errors in Excel.
Where do I manage Excel add-ins on macOS?
Open Microsoft Excel, click on the 'Tools' option in the top Apple menu bar, and select 'Excel Add-ins' from the dropdown to view, enable, or disable your extensions.
