Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 860
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you invert your selection of cells in excel? Jon Excel Discussion (Misc queries) 4 May 4th 23 07:43 PM
Invert excel data PJ Excel Worksheet Functions 5 November 8th 06 12:01 AM
Excel 2007 Selection too large PaulW Excel Discussion (Misc queries) 5 October 25th 06 07:21 AM
How do I invert a column in Excel? 3-togo Excel Discussion (Misc queries) 1 February 8th 06 03:27 PM
Invert Excel Selection Significent Excel Discussion (Misc queries) 0 March 12th 05 01:51 AM


All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"