Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you invert your selection of cells in excel? | Excel Discussion (Misc queries) | |||
Invert excel data | Excel Worksheet Functions | |||
Excel 2007 Selection too large | Excel Discussion (Misc queries) | |||
How do I invert a column in Excel? | Excel Discussion (Misc queries) | |||
Invert Excel Selection | Excel Discussion (Misc queries) |