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].