ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Select » Inverse selection...

This utility will invert your selection.
It will ask you to select a range, and extract your current selection from it. What remains is a selection which consists of the new cells, but without your initial selection.
This can be useful for example when you want to select a lot of cells, except for a few ones. This is a bit of the opposite of the "Deselect cells..." utility.

Screenshots

Starting this utility

In the Excel menu choose: ASAP Utilities » Select » Inverse selection...

« Return to the list of “Select” tools.

« Previous
Deselect cells...

Next »
Merge selection of selected areas

You can do this too

Download "The one essential add-in for all Excel users."

Additional keywords for this tool:
Swap, deselecting, unselect

Printer friendly page

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