Turning Off Cell Border Double-Click

[James]

When I double-click to select or edit the contents of a
cell, the worksheet jumps to either the top or bottom of
the worksheet (cell border double-clicked). How do I turn
this "feature" off?

 

[jr]

That's a HANDY feature if you use it right. That feature
will take you to the last cell of a continuous range
(same as CTRL-rt arrow or CTRL-dn arrow). It's not
invoked unless you double click on the border of the cell
so, if you disable, my guess is that NOTHING would happen
since you didn't click IN the cell. Best way to avoid
the result you don't like is to ensure that you're in the
center of a cell when you click or double click.

 

[James]

Thanks for your reply, but

My co-workers and I HATE this feature.

We want to turn it OFF.

We mainly work with large spreadsheets that must be in a
certain format that forces our data to be in one large
contiguous block. One mis-click and you're at row 12947
instead of row 3450.

We all experience this annoyance multiple times a day.

 

[Laura Cook]

If you don't use Cell Drag and Drop, then your annoyance can be turned off.

Go to Tools > Options > Edit (tab) and uncheck the box for "Allow cell drag
and drop".

 

[James]

thanks Laura,

We're deciding between the lesser of two evils:

(1) turn off the annoyance
(2) lose cell drag n drop

 

[Laura Cook]

It's funny, until I read your post, I did not even know that when you select
a cell and then double click on a border it would move as it does.

What reasoning do you have for going through the above motions (causing the
annoyance)? Usually, if I want to edit within a cell, I don't bother
selecting it first and then double clicking, just double click on the cell
straight away. Or, if the cell is already selected, I usually click in the
formula bar and start editing.

Just wondering

 

[James]

Oh, we usually have our fonts smaller or
zoom out to 80-90% so we can see more of
the worksheet. This is important due to
the nature of the data we work on.

so, when we double-click on a cell to edit the contents,
we get the annoyance about 1 out of 5 times.
But when it does happen (and it happens several times
a day) it's very aggravating because you lose your
spot in the worksheet. It's extremely aggravating when
we're onsite and have to make changes to our systems
and are trying update the worksheet, etc....

And, we cannot put breaks in our worksheet since the data
gets exported to another program which halts the import
process when it sees a CRLF

Yeah, I guess it could sound trivial.

 

[Dave Peterson]

I edit in the formula bar. But maybe you could train yourself (and others) to
hit F2 instead of double clicking.

(Just another option for those who don't want to lose drag and drop.)

And Dana DeLouis gave a neat tip a few months ago:
http://groups.google.com/[email protected]

Excel has a built in feature that remembers it's last 4 locations. It is
usually used in Macros, but you can access this feature manually.
With your cell selected, (say z100), select the name box....and just hit
enter.

This adds the current selection to Excel's memory.
Now move your selection back to A1.
Hit F5 to bring up the "GoTo" feature, and just hit enter to return to z100.
If you hit F5 at a later time, and z100 is not the "Previous" location, you
still might be able to select it from the list.
HTH. :>)


========
I don't think that something like this would be effective to do everytime you
change your selection, but it might be neat to show off to your coworkers!

 

[James]

That's actually quite useful!
I can hit F2 then do a SHIFT-CTRL-LEFT ARROW or SHIFT-HOME
to select the entire cell. (I prefer keyboard shortcuts)

Thanks Dave & Laura for your great advice!