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

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. You may avoid unintentional modifications and streamline your work process by adhering to a few straightforward procedures. This tutorial will provide you the skills to change the default behaviour and improve your Excel experience, whether you are a novice or a seasoned user. Here we will make the changes to the Excel options to complete the task. Then click on advanced, uncheck the box named "Enable file handling and cell drag and drop," and click OK to complete the task. To enable the feature, check the box and click OK. This is how you can disable double click on cell border in excel. Pradeep Kumar. Updated on: Jul How to prevent or disable edit mode by double-clicking a cell in Excel? How to border cells based on cell values in Excel?

It at least puts me back to where I was when this annoying feature "aided" me in my endeavors.

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.

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?

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. I'm going crazy over the jumping "feature" when double clicking a cell border in Microsoft Excel.

Aveeno sunblock lotion

Browse other questions tagged microsoft-excel microsoft-excel Top Contributors in Excel:. The feature can be turned off, fortunately. Choose where you want to search below Search Search the Community. Mikes answer works but unfortunately you you lose both the irritating double click feature but also your drag and fill. Modified 3 years ago. Not the answer you're looking for? Double click is important to paste unformatted text from the clipboard. Gord Dibben. Upcoming privacy updates: removal of the Activity data section and Google The cell could be anywhere so I need to use the mouse for this. How to disable double-click on cell border in Excel?

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.

In earlier versions of Excel you could go into Excel Options and uncheck "allow cell drag and drop". If you're going to tell me this is "by design", then fire your stupid designer. Er, we don't have to remove it I tried to cancel the double-click with VBA into the BeforeDoubleClick event but it is not triggered when the border is double-clicked Cancel Submit. Ask a new question. Yes No. If you just left click a cell and start typing on your keyboard you should be able to just go ahead and edit the cell. This thread is locked. This is very annoying when zoomed far out dealing with large amounts of data.