How do I invert a selection in Excel 2007?

G

Guest

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.
 
M

MartinW

Hi Chase,

Data>Sort 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 Data>Sort on the helper column

HTH
Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you invert your selection of cells in excel? 3
How do i invert text in Excel 3
How do I invert a column in Excel? 1
Can I invert a matrix in Excel 2007? 2
how do i flip a column round in excel? 4
Prevent SORT from asking to expand selection in Excel 2007? 4
How To Clear Previous Selection From a Drop Down 2
how do I send selected cells in an e-mail using excel 2007? 1

Top