How do I invert a selection in Excel 2007?
 

In most applications it is Edit - Invert selection. I've spent time
searching help, the KB, etc and can't find it. I'm sure it's quite simple and
I'll feel like an idiot once someone points it out...

Thank you.

How do I invert a selection in Excel 2007?
 

Hi Chase,

DataSort is what you are looking for.

If your data is not already sorted in some way you will
need to add a helper column.
Put 1 in the first cell, grab the fill handle and drag it down
to the end of your data, hold down Ctrl and let go the left button.
Then select both your data and the helper column
and do DataSort on the helper column

HTH
Martin



"Chase" wrote in message
...
In most applications it is Edit - Invert selection. I've spent time
searching help, the KB, etc and can't find it. I'm sure it's quite simple
and
I'll feel like an idiot once someone points it out...

Thank you.