You can do this too
Download now, it's easy
ASAP Utilities menu
Language:
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
Example screenshot: 1 Before
Example screenshot: 2 Select the range to inverse
Example screenshot: 3 After The selection is inversed
Starting this utility
In the Excel menu choose ASAP Utilities » Select » Inverse selection...Additional keywords:
Swap
Swap
« Return to the list of “Select” utilities.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 