logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“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
1 Excel error, select a single range
Example screenshot: 2 Your selected areas transformed to one single range
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.
«
Inverse selection...
 
  »
Select adjacent cells below active cell with the same value
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
Merged

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook