Home

Excel on Android - numeric keypad

%3CLINGO-SUB%20id%3D%22lingo-sub-352370%22%20slang%3D%22en-US%22%3EExcel%20on%20Android%20-%20numeric%20keypad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-352370%22%20slang%3D%22en-US%22%3E%3CP%3EMost%20of%20my%20data%20entry%20in%20Excel%20is%20numeric%2C%20and%20I%20really%20like%20to%20choose%20the%20dedicated%20keyboard%20for%20number%20entry.%20There%20are%20three%20minor%20issues%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ESometimes%20when%20I%20go%20back%20to%20Excel%20after%20a%20while%20it%20has%20defaulted%20back%20my%20standard%20keyboard%20(I%20used%20Gboard).%26nbsp%3B%20Minor%20nuisance%2C%20because%20I%20have%20to%20reselect.%3C%2FLI%3E%3CLI%3EIn%20any%20case%2C%20an%20option%20to%20automatically%20select%20this%20keyboard%20when%20a%20cell%20is%20formatted%20as%20one%20of%20the%20number%20type%20would%20be%20useful%20(and%20the%20opposite%20for%20text)%3C%2FLI%3E%3CLI%3EThe%20keyboard%20should%20use%20the%20system%20defaults%20for%20keyboard%20sound%20and%20vibration.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20pretty%20minor%2C%20but%20I%20feel%20they%20get%20between%20me%20and%20one%20of%20the%20most%20useful%20pieces%20of%20Android%20software.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391577%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Android%20-%20numeric%20keypad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391577%22%20slang%3D%22en-US%22%3E%3CP%3EAppreciate%20the%20feedback.%3C%2FP%3E%0A%3CP%3EWill%20look%20into%20it%20and%20get%20back.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-391470%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Android%20-%20numeric%20keypad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-391470%22%20slang%3D%22en-US%22%3E%3CP%3EOK%2C%20a%20bit%20more%20information.%26nbsp%3B%20It's%20working%2C%20to%20some%20extent.%26nbsp%3B%20Here's%20a%20sequence...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EOpen%20a%20XLSX%3C%2FLI%3E%3CLI%3EClick%20on%20a%20cell%20known%20to%20be%20formatted%20as%20a%20number%3C%2FLI%3E%3CLI%3EClick%20the%20function%20bar%20to%20enter%20a%20value.%26nbsp%3B%20At%20this%20time%2C%20the%20on-board%20keyboard%20appears.%26nbsp%3B%20I'm%20using%20gboard%2C%20and%20it's%20just%20the%20regular%20QWERTY%20layout%3C%2FLI%3E%3CLI%3EBefore%20entering%20a%20value%2C%20click%20on%20another%20numeric%20format%20cell.%20Now%20the%20numeric%20keyboard%20does%20appear.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThis%20is%20on%20a%20Galaxy%20S8%2B.%26nbsp%3B%20Maybe%20I'm%20missing%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-364196%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Android%20-%20numeric%20keypad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364196%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20seeing%20the%20number%20keyboard%20auto-surface%20-%20I'm%20on%201.0.1%20(16.0.11425.20016).%26nbsp%3B%26nbsp%3B%20For%20example%2C%20this%20is%20on%20cells%20formatted%20as%20%22Number%22%2C%20zero%20decimal%20places.%26nbsp%3B%20Thanks.....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363137%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Android%20-%20numeric%20keypad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363137%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20the%20feedback!%3CBR%20%2F%3ECan%20you%20check%20this%20on%20the%20latest%20Beta%20build%3F%3CBR%20%2F%3EWe%20have%20included%20auto-surfacing%20the%20number%20keyboard%20based%20on%20cell%20formatting.%20%3CBR%20%2F%3EWe%20will%20look%20into%20the%20other%20feedbacks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-528702%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20on%20Android%20-%20numeric%20keypad%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-528702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F297383%22%20target%3D%22_blank%22%3E%40Siddharth_Vora%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3EI'm%20using%20Excel%201.0.1%20(16.0.11601.20074)%20on%20Lenovo%20TB3-730x%20very%20often%26nbsp%3Bevery%26nbsp%3Bday.%3C%2FP%3E%3CP%3EMy%20question%20is%3A%20is%20it%20possible%20to%20%3CU%3Epermanently%3C%2FU%3E%20disable%20the%20switching%20between%20the%20various%20keyboard%20based%20on%20cell%20formatting%2C%20since%20for%20me%20this%20auto-surfacing%20is%20counterproductive%3A%20the%20Hacker's%20Keyboard%2C%20the%20default%20keyboard%20I'm%20using%2C%20already%20has%20all%20the%20necessary%20letters%20and%20numbers%20I%20need.%3C%2FP%3E%3CP%3EThanks%20for%20your%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E
blackcat
Occasional Contributor

Most of my data entry in Excel is numeric, and I really like to choose the dedicated keyboard for number entry. There are three minor issues:

 

  • Sometimes when I go back to Excel after a while it has defaulted back my standard keyboard (I used Gboard).  Minor nuisance, because I have to reselect.
  • In any case, an option to automatically select this keyboard when a cell is formatted as one of the number type would be useful (and the opposite for text)
  • The keyboard should use the system defaults for keyboard sound and vibration.

 

All pretty minor, but I feel they get between me and one of the most useful pieces of Android software.

5 Replies

Thank you for the feedback!
Can you check this on the latest Beta build?
We have included auto-surfacing the number keyboard based on cell formatting.
We will look into the other feedbacks.

I'm not seeing the number keyboard auto-surface - I'm on 1.0.1 (16.0.11425.20016).   For example, this is on cells formatted as "Number", zero decimal places.  Thanks.....

OK, a bit more information.  It's working, to some extent.  Here's a sequence...

 

  • Open a XLSX
  • Click on a cell known to be formatted as a number
  • Click the function bar to enter a value.  At this time, the on-board keyboard appears.  I'm using gboard, and it's just the regular QWERTY layout
  • Before entering a value, click on another numeric format cell. Now the numeric keyboard does appear.

This is on a Galaxy S8+.  Maybe I'm missing something?

Appreciate the feedback.

Will look into it and get back.

@Siddharth_Vora 

 

Good day,

I'm using Excel 1.0.1 (16.0.11601.20074) on Lenovo TB3-730x very often every day.

My question is: is it possible to permanently disable the switching between the various keyboard based on cell formatting, since for me this auto-surfacing is counterproductive: the Hacker's Keyboard, the default keyboard I'm using, already has all the necessary letters and numbers I need.

Thanks for your reply.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies