Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Normally, when you double-click a cell, you enter in-cell editing mode, right? This works most of the time, but occasionally on random cells, a double-click instead moves the focus to a different cell in the sheet, as if I had simply single-clicked that other cell. If I then double-click the original cell again, it works as expected: I can edit the contents of that cell and everything is normal.

This happens on random cells, regardless what their contents are, and of course they're not hyperlinked or anything like that. It happens on several versions of Excel (XP, 2000, 2003, for certain; can't remember earlier versions). It happens on any computer (at home, at work, at previous workplace...).

This is not a major problem I need to have solved, but why in the world is Excel behaving like that?! I'd just like to understand it.

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

If you double click on (or really near) the border of the cell, the selected cell jumps to the first empty cell to the left in the same row (if it was a side border) or up in the same column (if it was a top/bottom border).

It seems to be more reliable if your cursor is closer to a corner rather than in the middle of a border.

share|improve this answer
    
+1 - Reproduced in 2007. Solution - click carefully in the middle of the cell, or use F2! –  JNK Sep 17 '10 at 19:32
    
Wow, I never noticed a connection between where in the cell I was clicking and the jump direction; it just seemed so random. I also didn't notice that the random target cell was always blank. Wow. Been using Excel since version 0.95 on the Mac in 1986 and still learn new tricks. Amazing! –  Torben Gundtofte-Bruun Sep 17 '10 at 20:09
    
Haha, this happened to me as well, and I eventually realized that it would happen if you double click the border - really frustrating. +1 to the answer though. –  Kevdog777 May 21 '13 at 8:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.