Doubleclik on border of cell

  • Thread starter Thread starter Marc Gritter
  • Start date Start date
M

Marc Gritter

Hello,

When I doubleclick on the bottom border of a cell in Excel, the selected
cell changes to last cell of the column. Is it possible to turn of this
feature?

Greetings,

Marc
 
Hi

I don't think it's possible to turn this 'feature' off! It also does it
double-clicking on the other borders - so watch out!
 
<Tools> <Options> <Edit> tab,

And *uncheck* "Allow Cell Drag And Drop".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hello,

When I doubleclick on the bottom border of a cell in Excel, the selected
cell changes to last cell of the column. Is it possible to turn of this
feature?

Greetings,

Marc
 
I don't believe that you truly realize all the functionality that you're
surrendering, just to avoid an annoyance!
 
Hi Marc,
Could not have said that much better than Rag Dyer but not going
to let that stop me from giving you an idea of what you are missing.

See -- Fill-Handle, Replication and use of the Mouse
http://www.mvps.org/dmcritchie/excel/fillhand.htm

You won't be able to use the fill-handle to copy (replicate) formulas down.
Double-clicking the fill handle is one of the neatest devices, even neater
than dragging the fill handle.
The Fill Handle is documented in Help okay.
You will have a bit more of a problem finding the information for the mouse
looking through Help, but it is there somewhere.
Dragging a column with mouse is a heck of a lot easier and more reliable
than trying to use Cut and Paste to move columns around.

If you look at how the mouse pointer changes on the cell you can tell
where you are at. If you hit the border accidentally that isn't far from the
next cell so you don't particularly avoid having to look at what you
are doing. Without drag and drop you don't see the pointer change
as it crosses the border. With cell drag and drop you see the cell
pointer change as it crosses a cell border which should be more
reassuring that you have the mouse right where you want him..

In other words if you look at my page above, most of those neat things
you will not be able to do.

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
Back
Top