Needless Feature Constantly Interferes with Data Entry While Using Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-130630%22%20slang%3D%22en-US%22%3ENeedless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130630%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20working%20on%20a%20simple%20Excel%20task....%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello%2C%20I%20often%20have%20to%20correct%20data%20in%20excel%20and%20there%20is%20a%20feature%20in%20excel%20that%20is%20interfering%20with%20my%20work.%20I'm%20sure%20that%20other%20people%20that%20do%20any%20kind%20of%20data%20entry%20have%20come%20across%20this%20feature%20and%20are%20simply%20working%20around%20it.%20It%20took%20me%20some%20time%20before%20I%20got%20fed%20up%20and%20decided%20to%20write%20you%20guys.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3ESo%2C%20what%20happens%3F%20I%20will%20double%20click%20on%20a%20cell%20in%20excel%20and%20my%20cursor%20goes%20to%20the%20bottom%20of%20the%20excel%20sheet%20data%20column.%20Maybe%20I%20accidently%20clicked%20on%20a%20line%20but%20I%20do%20not%20want%20to%20have%20to%20reset%20my%20cursor%20position%20every%20time%20I%20intend%20to%20double%20click%20on%20a%20cell.%20It%20is%20very%20annoying%20and%20it%20breaks%20my%20work%20momentum.%20It's%20like%20every%20other%20time%20I%20double%20click%20something%20in%20excel%2C%20my%20cursor%20just%20goes%20to%20the%20bottom%20of%20that%20excel%20column%20in%20that%20worksheet.%20I%20don't%20understand%20why%20this%20feature%20exists.%20It%20makes%20my%20life%20harder%20than%20it%20needs%20to%20be.%20Seriously%2C%20why%3F%20Someone%2C%20please%20do%20something%20about%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-130630%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130782%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130782%22%20slang%3D%22en-US%22%3E%3CP%3EVery%20strange.%20Checked%20right%20now%20from%20the%20link%20in%20the%20post%20-%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130661%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130661%22%20slang%3D%22en-US%22%3E%3CP%3EActually%20its%20%22forbidden%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130659%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130659%22%20slang%3D%22en-US%22%3E%3CP%3EThanks.%20That%20page%20gave%20me%20a%20404...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130658%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130658%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20available%3A%20Ctrl%2BUp%2C%20Ctrl%2BDown%2C%20etc.%20In%20Excel%20practically%20everything%20could%20be%20done%20by%20few%20several%20ways.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%20right%20place%20with%20suggestions%20to%20add%2Fremove%20this%20or%20that%20feature%20is%20user%20voice%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130645%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130645%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sure%20there%20could%20be%20another%20way%20to%20activate%20that%20feature%20without%20clicking%20on%20the%20border%2C%20given%20that%20accidently%20clicking%20on%20the%20border%20happens%20so%20often.%20It's%20very%20easy%20to%20accidently%20click%20on%20the%20border.%20How%20about%20making%20that%20feature%20available%20via%20a%20keyboard%20shortcut%2C%20or%20right%20click%20and%20then%20clicking%20on%20a%20menu%20item...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130644%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130644%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20sure%20there%20could%20be%20another%20way%20to%20activate%20that%20feature%20without%20clicking%20on%20the%20border%2C%20given%20that%20accidently%20clicking%20on%20the%20border%20happens%20so%20often.%20It's%20very%20easy%20to%20accidently%20click%20on%20the%20border.%20How%20about%20making%20that%20feature%20available%20via%20a%20keyboard%20shortcut%2C%20or%20right%20click%20and%20then%20clicking%20on%20a%20menu%20item...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-130642%22%20slang%3D%22en-US%22%3ERe%3A%20Needless%20Feature%20Constantly%20Interferes%20with%20Data%20Entry%20While%20Using%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-130642%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Mel%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMore%20exactly%20it%20happens%20when%20you%20double%20click%20the%20border%20around%20the%20selected%20cell.%20Double%20click%20on%20the%20cell%20(within%20the%20border)%20shifts%20you%20into%20cell%20edit%20mode.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20quite%20useful%20feature%20(I%20mean%20with%20border)%2C%20I%20use%20it%20quite%20often.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Just working on a simple Excel task....

 

Hello, I often have to correct data in excel and there is a feature in excel that is interfering with my work. I'm sure that other people that do any kind of data entry have come across this feature and are simply working around it. It took me some time before I got fed up and decided to write you guys.


So, what happens? I will double click on a cell in excel and my cursor goes to the bottom of the excel sheet data column. Maybe I accidently clicked on a line but I do not want to have to reset my cursor position every time I intend to double click on a cell. It is very annoying and it breaks my work momentum. It's like every other time I double click something in excel, my cursor just goes to the bottom of that excel column in that worksheet. I don't understand why this feature exists. It makes my life harder than it needs to be. Seriously, why? Someone, please do something about this.

9 Replies

Hi Mel,

 

More exactly it happens when you double click the border around the selected cell. Double click on the cell (within the border) shifts you into cell edit mode.

 

IMHO, quite useful feature (I mean with border), I use it quite often.

I'm sure there could be another way to activate that feature without clicking on the border, given that accidently clicking on the border happens so often. It's very easy to accidently click on the border. How about making that feature available via a keyboard shortcut, or right click and then clicking on a menu item...

I'm sure there could be another way to activate that feature without clicking on the border, given that accidently clicking on the border happens so often. It's very easy to accidently click on the border. How about making that feature available via a keyboard shortcut, or right click and then clicking on a menu item...

It's available: Ctrl+Up, Ctrl+Down, etc. In Excel practically everything could be done by few several ways.

 

In general right place with suggestions to add/remove this or that feature is user voice https://excel.uservoice.com/

 

Thanks. That page gave me a 404...

Very strange. Checked right now from the link in the post - works.

Being able to disable the double-click-on-border feature is a request that gathered many hundreds of votes on UserVoice, but never got any response at all from Microsoft. Many of the votes were very entertaining expressions of the inordinate amount of frustration that one feels when working on a huge spreadsheet, having found the cell you want to edit, double-clicking ... and ending up ten thousand cells away at the bottom of the sheet, with no way to jump back to where you came from and continue your work.

I'm looking for the most current Tech Community location where a similar aggregation of users' frustrations is happening about this issue, so that I can add my vote there. Does anyone have a pointer to something more recent than this discussion?