LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default Cell Selection in Excel

It seems that folks tend to mix up what they do in XL and what they do (did)
in Windows Explorer.

Windows Explorer has an <Edit. <Invert Selection option,
Just as it also has a de-select feature if you re-click on a selected item.

On occasion, I myself will waste a couple of minutes searching, before
remembering that they *only* exist in Explorer.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
Maybe you are thinking of Go To (keyboard shortcut F5), then special but
there has never been a built in function that when you select A1:B9 then
click editinverse and it will select all cells except this range



--


Regards,


Peo Sjoblom


"Ray" wrote in message
...
I tend to experiment with different formulas in the outlying cells when
working on a spreadsheet, i know it was there in earlier editions(ie 2000
or
before) just getting tired of the extra steps to delete my doodleing.
--
RGDS,

RAY


"Peo Sjoblom" wrote:

When was it out there? There has never been an inverse command, Either
you
had an add-in or you mistook it for some other application, for instance
if
you select files in windows explorer you have this option under edit



--


Regards,


Peo Sjoblom



\\"Ray" wrote in message
...
Previous versions of Excel had an "Invert Selection" command under the
Edit
heading. If you had selected cell A1:B9 and selected this option it
would
select all cells except A1:B9. Is this command still out there or am
I
just
a blind old fool?









 
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
Excel Yes / No, True / False etc. cell selection buttons? Harrison[_2_] Excel Worksheet Functions 1 July 4th 07 04:50 AM
Excel sheet: selection of cell or rows not visible. Hisoul Excel Worksheet Functions 2 May 16th 07 09:06 PM
Cell Selection in Excel RM Batcha Excel Discussion (Misc queries) 1 April 27th 07 08:07 AM
First row in Selection range (first index of a cell) EXCEL VBA [email protected] Excel Worksheet Functions 1 March 20th 06 09:38 PM
Set a cell to have a pop-up calendar for date selection in Excel? Michigander-77 Excel Worksheet Functions 2 July 14th 05 11:51 PM


All times are GMT +1. The time now is 12: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"