The ASAP Utilities menu in Excel (English)
Merge selection of selected areas
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Select › 6. 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 tool
- Click ASAP Utilities › Select › 6. Merge selection of selected areas
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Additional keywords for this tool:
Merged
Merged