Cell Selection in Excel

[Ray]

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?

 

[Peo Sjoblom]

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]

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.

 

[Gord Dibben]

"Previous" to which version?

I can't remember seeing this command on the Edit menu in versions 95 through
2003.

Perhaps it was an add-in that gave you that command?


Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

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 edit>inverse and it will select all cells except this range



--


Regards,


Peo Sjoblom

 

[RagDyer]

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.