|
|
You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Select » Merge selection of selected areas
This utility merges multiple contiguous selections (areas) of cells into a new selection.Sometimes Excel needs one selected range to perform certain actions and gives you the error "The command you chose cannot be performed with multiple selections. Select a single range and click the command again.".
If the resulting selection is a solid square range you can use this utility to combine the multiple selections into a new single selection.
If the individual selections together make a contiguous rectangle, you can use this tool to create a new single selection.
For example when your select the range [A10:A50] and [B10:B50], this tool will make it one selection: [A10:B50].
Screenshots
Example screenshot: 1 Excel error, select a single range
Example screenshot: 2 Your selected areas transformed to one single range
Starting this utility
In the Excel menu choose: ASAP Utilities » Select » Merge selection of selected areas« Return to the list of “Select” tools.
| « Previous Inverse selection... | Next » Select adjacent cells below active cell with the same value |
 - 750px - ribbon.png "Download ASAP Utitilities")
Download ASAP Utilities
Additional keywords for this tool:
Merged
Merged
Follow ASAP Utilities on Facebook
© 1999-2018 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
