Excel disable double click jump

February 13, Ask a new question.

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

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 double clicked on. How do you disable this? If you don't need to use those features and are OK with unchecking that checkbox, then this solution will work for you. Check this box. I tested this solution in Excel and it works immediately after unchecking the box and saving. The change that you see is that with the checkbox checked, and with a cell selected, the "plus sign" cursor converts to a four-arrow cursor arrows that have ends in center and each point along axis -- i. With the checkbox off, that arrow cursor never appears. Also, of course, if you double-click the selected cell edge, you are not navigated to the bottom of your section, automatically. 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. It at least puts me back to where I was when this annoying feature "aided" me in my endeavors. Mikes answer works but unfortunately you you lose both the irritating double click feature but also your drag and fill. Alternative solution - Get out of the habit of double clicking a cell.

February 13, Top Contributors in Excel:. Again, could be anywhere.

February 13, Ask a new question. Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback.

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. Yes, you can disable this which will also disable the fill handle and dragging-dropping of cells :. Explore Teams Create a free Team.

Excel disable double click jump

Contribute to the Microsoft and Office forum! March 14, March 11, Ask a new question. I am clearly working on a different part of the table and always have to scroll up to find it again. If this is a feature, is there a way to switch it off? To disable it, follow the below steps:. Was this reply helpful? Yes No. Sorry this didn't help.

Vimal pan masala owner family

Jim Deveau. Newest First. Alternatively, double left click followed by typing will insert what you typed at the cursor location when you did the double click. My workflow definitely shouldn't include scrolling You don't need to double-click to select a cell, one will do. Although this "solution" seems obvious, it requires the user to concentrate on the use of the application instead of on his own work. This surely can't be a workflow unique to me? If you're going to tell me this is "by design", then fire your stupid designer. Palcouk Volunteer Moderator. February 13, Top Contributors in Excel:. Why can't MS just let us turn this feature off?! To edit the content of a cell in a different way, you can : Edit directly the cell content from the formula bar, or Press the F2 key.

Contribute to the Microsoft and Office forum! March 14,

I have the same question Report abuse. I would be done by now, but double clicking a cell border jumps me to the top or bottom. Having just tested several sheets I am unable to replicate your issue with double click. Steps 1 and 4 involve fast clicking between cells so the "feature" is triggered regularly, but I don't want to zoom in because then I'd have to scroll more often when changing cells. Newest First. The feature can be turned off, fortunately. This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread. This is absolutely dumb. Down the rabbit hole in the Stack Exchange network. Alternative solution - Get out of the habit of double clicking a cell.