logo ASAP Utilities

Tip of the Day | Sunday August 14th, 2022

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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 tool

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Inverse selection...



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us