View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Thomas [PBD] Thomas [PBD] is offline
external usenet poster
 
Posts: 154
Default Double Clicking in Cell-- unwanted move

Kim,

There are a couple alternatives, after I searched Google for the answer.

1: You can lose Drag and Drop feature, which will stop this.
ToolsOptionsEdituncheck "Allow Cell Drag and Drop"

2:Excel remembers the last 5 moves made if you were working in a cell, say
you were working in A5, and double-click the border, takes you to cell
A16514, Press F5 and Enter, it will take you back to A5.

3: Pressing F2, instead of double-clicking.

4: Increase the Zoom on the page to eliminate this.

Other than that, there isn't anything that we can do..

--
--Thomas [PBD]
Working hard to make working easy.


"KIM W" wrote:

Can one disable the ittirating Excel behavior of moving you to another cell
when you double click on the border of a cell?
We do a lot of in cell editing, and if one accidentally double clicks on top
border of cell, it moves you to the next empty or last occupied cell above
you. (Just like ctl+Up Arrow, etc.) This can move you to an unwanted location
far away from where you were editing.