View Single Post
  #4   Report Post  
Bob Umlas
 
Posts: n/a
Default

The answers you've gotten to deselect are simply not true. There's really no
EASY way to do this witihout either using ASAP Utilities, perhaps some other
utility, or, once you've made a mistake, you can stop at that point and give
your range a name (type a temporary name like "x" in the name box), then
using insert/name/define, edit the "bad" cell out of the name "x", then use
Edit/goto x and continue with what you were doing!

Bob Umlas
Excel MVP

"Sloth" wrote in message
...
I discovered you can use the ctrl key to select non-adjacent cells. Is

there
a way to deselect certain cells? Sometimes if I am selecting many cells I
might select an extra row on accident. In which case I need to start over
selecting the cells. Also if I select a range of cells (for instance,

A1:G9)
can I deselect certain cells? For instance A1:G9 except A3,B7, and F9. I
know this seems like a silly question, but I would just like to know if

there
is an answer to this.