Excel disable double click jump

Connect and share knowledge within a single location that is structured and easy to search. I'm not sure whether this is a feature but it's very irritating. When you double click on a border of a selected cell, you go to the end of the list depending on which side of the selected cell you excel disable double click jump clicked on. How do you disable this?

February 13, Ask a new question. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. In earlier versions of Excel you could go into Excel Options and uncheck "allow cell drag and drop".

Excel disable double click jump

Normally, we double click on a cell to edit the cell content, however, the cursor jumps to bottom of the worksheet data as you may click on the cell border accidentally as following screenshot shown. This may be annoying if there are multiple rows, you should scroll up to the clicked cell. This article, I will talk about how to disable double-click on cell border in Excel. Disable double-click on cell border to jump to bottom. To disable double-click on cell border feature, you can go to the Excel Options to configure an option, please do as this:. In the Excel Options dialog box, click Advanced option from the left pane, and then uncheck the Enable fill handle and cell drag-and-drop option under the Editing options, see screenshot:. Then click OK to close this dialog box, and now, double-click on cell border feature is disabled at once. Skip to main content. How to disable double-click on cell border in Excel? Disable double-click on cell border to jump to bottom Disable double-click on cell border to jump to bottom To disable double-click on cell border feature, you can go to the Excel Options to configure an option, please do as this: 1. In the Excel Options dialog box, click Advanced option from the left pane, and then uncheck the Enable fill handle and cell drag-and-drop option under the Editing options, see screenshot: 3.

February 13, Top Contributors in Excel:.

February 13, Ask a new question. Just writing to complain about this feature. People had issues with this back in and it still hasn't been fixed. Double-clicking on a cell slightly incorrectly causes excel to jump to the bottom of the sheet. This is very annoying when zoomed far out dealing with large amounts of data.

Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams. Connect and share knowledge within a single location that is structured and easy to search. I'm going crazy over the jumping "feature" when double clicking a cell border in Microsoft Excel. Is there a way to disable it? It sounds like you are talking about the 4-direction arrow icon that appears when you hover over a cell border.

Excel disable double click jump

Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams. Connect and share knowledge within a single location that is structured and easy to search. 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, , , 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?!

Picture of a maltese

The Overflow Blog. Yes No. How to specify double border using CSS? Was this reply helpful? Hi Microsoft, It's and this problem still exists. To enable the feature, check the box and click OK. Check this box. In reply to YarivPorters's post on December 9, Browse other questions tagged microsoft-excel microsoft-excel To disable double-click on cell border feature, you can go to the Excel Options to configure an option, please do as this:. I'm not sure whether this is a feature but it's very irritating. Regards JY pc. And if I do, Ctrl-Arrow is simple enough. This site in other languages x. MandyZhou Ashley.

We often need to find out which dataset consists of our formula.

Regards JY. Cancel Submit. I tested this solution in Excel and it works immediately after unchecking the box and saving. Your understanding is highly appreciated. This is very basic things Sorted by: Reset to default. To disable double-click on cell border feature, you can go to the Excel Options to configure an option, please do as this:. Is there a way to improve this, other than growing a third hand or pressing F2 with my nose? Yes No. I tried to cancel the double-click with VBA into the BeforeDoubleClick event but it is not triggered when the border is double-clicked Yes No. Top Contributors in Excel:. Pradeep Kumar.