PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 1.00 average.

How do I invert a selection in Excel 2007?

 
 
=?Utf-8?B?Q2hhc2U=?=
Guest
Posts: n/a
 
      18th Sep 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.
 
Reply With Quote
 
 
 
 
MartinW
Guest
Posts: n/a
 
      18th Sep 2007
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



"Chase" <(E-Mail Removed)> wrote in message
news:47E083EA-67E4-4AB8-B6C0-(E-Mail Removed)...
> 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.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can i invert the selection of cells in Microsoft Excel 2007 heya Microsoft Excel Worksheet Functions 2 17th May 2010 09:40 PM
Can I invert a matrix in Excel 2007? Roger Hn Microsoft Excel Worksheet Functions 2 28th Jan 2010 01:44 PM
How do you invert your selection of cells in excel? =?Utf-8?B?Sm9u?= Microsoft Excel Misc 3 4th Mar 2007 11:18 AM
Invert Excel Selection =?Utf-8?B?U2lnbmlmaWNlbnQ=?= Microsoft Excel Misc 0 12th Mar 2005 01:51 AM
In Excel, make Invert option to reverse order of copy selection. =?Utf-8?B?RGVhbmJhZzEyMzQ1?= Microsoft Excel Misc 1 25th Sep 2004 07:09 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:15 AM.