You can do this too
Download now, it's easy
ASAP Utilities menu
Language:
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 message, The command you chose cannot be performed with multiple selections
Example screenshot: 2 Example with multiple adjacent selections making a 'square' selection
Example screenshot: 3 Result one selection which Excel can use for example its subtotals
Starting this utility
In the Excel menu choose ASAP Utilities » Select » Merge selection of selected areasAdditional keywords:
Merged
Merged
« Return to the list of “Select” utilities.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 