Forum Discussion

blackcat's avatar
blackcat
Copper Contributor
Feb 18, 2019

Excel on Android - numeric keypad

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.

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

    • sjhart29's avatar
      sjhart29
      Copper Contributor
      I hate that yall took the keyboard / number pad selection off. I have spreadsheets that in the "auto-surfacing" update that I need the keyboard but only have use of the number pad and vice-versa. Please change it back. This is NOT a good update.
      • Katherine14121300's avatar
        Katherine14121300
        Copper Contributor
        Hi! I read you comment, is that true?.
        I'm just looking for an answer, why in one of my tablet, excel gives me an option to switch between ABC keyboard to numeric panel, and in other not ?
        If someone knows please I need help with this..
        Thanks
    • blueskies's avatar
      blueskies
      Copper Contributor

      Siddharth_Vora 

       

      I'd like to follow up on this and ask how I can format a cell so that the numeric keyboard pops up when I go to enter a value. (I'm assuming that what "auto-surfacing the number keyboard based on cell formatting" means.) Thanks!

      • Siddharth_Vora's avatar
        Siddharth_Vora
        Icon for Microsoft rankMicrosoft

        blueskies you can format the cell as numeric, currency, date, time, datetime.

        In that case double tapping the cell to edit should bring up the numeric keyboard.

    • alex_the_007's avatar
      alex_the_007
      Copper Contributor

      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.

      • ESoggy's avatar
        ESoggy
        Copper Contributor
        Very frustrating! Now I'm trying to type in a string and it keeps bringing me the numbers keyboard. I can't change the keyboard back to alphanumeric.

        Microsoft should include a user setting to enable or disable this feature

Resources