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 excel disable double click jump cell, you go to the end of the list depending on which side of the selected cell you double clicked on. How do you disable this?

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:.

Excel disable double click jump

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. FYI I know that I can untick the 'Enable fill handle and cell drag-and-drop' option, but this has knock-on effects when editing data. I also want to help you, given the situation, I'd like to invite you to submit this idea at our User Voice. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback.

February 13, Nope, and years later the idiots at Microsoft still haven't addressed this nightmare of a "feature. This is why i use LibreOffice whenever possible!

February 13, Ask a new question. I am trying to turn off the extremely annoying jump "feature" in Excel, where the focus jumps to distant cells whenever the cell border is accidentally double-clicked. I can see that many people have been asking about how to fix this issue for over ten years, with no improvements to the software and some suggested workarounds which don't seem appropriate for my workflow. Previous workarounds have generally been based on using F2 to enter cells instead of double-clicking.

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. When double-clicking on this, it will perform the equivalent of ctrl-arrow key moving to last filled cell in that direction.

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?

Rate my puss

I am sorry that it caused some inconvenience for you. Upcoming privacy updates: removal of the Activity data section and Google I don't have a solitution other than using F2 to stop this functionality, but to go back to where I was I use Control Z. Top Contributors in Excel:. Thanks for your feedback, it helps us improve the site. Edit: A single left click on a cell followed by typing will overwrite the cell's contents. How to prevent or disable edit mode by double-clicking a cell in Excel? The only solution I know of is using F2 instead of double clicking. I am trying to turn off the extremely annoying jump "feature" in Excel, where the focus jumps to distant cells whenever the cell border is accidentally double-clicked. How satisfied are you with this reply? This is absolutely dumb.

Spreadsheet creation, data analysis, and computations are all commonly done using the robust tool known as Excel. This frequently causes a cell to go into "Edit Mode," disturbing your work flow and sometimes changing important data.

In reply to NickHuh's post on April 16, Upcoming privacy updates: removal of the Activity data section and Google If you've also been affected by this issue feel free to add!! Check this box. Not the answer you're looking for? Is there really no way to separate these features? How to border cells based on cell values in Excel? Cancel Submit. This is very annoying when zoomed far out dealing with large amounts of data. Read More