Excel Keyboard Commands for iPad Pro

Discussion in 'iOS Apps' started by nalbagli, Jan 3, 2016.

  1. nalbagli macrumors 6502

    Joined:
    Sep 11, 2014
    #1
    Hi, I am a new iPad Pro owner and been loving it so far. One of my main problems with iPad productivity before was using excel as I am really used to work with a trackpad and it has been kind of difficult adapting to do most of the work with keyboard shortcuts but I've been adapting. There are some commands though that I haven't figured out yet and I don't know if they even exist for the iPad, but doing it with the keyboard is much faster for me, and I wanted to know if anyone knew that could help me out. (I have excel in spanish so I'll tray to explain myself as clear as possible)

    - First is really simple but I would like to know if there's a way to edit the formulas or text in a cell without deleting completely what is already witten on it, because whenever I select a cell with text or formulas if I start typingeverything that was written before is deleted and the only way to edit is touching the formula bar.

    - Another thing I use a lot is the reference or fix the cells, I really don't know the name of the function but it the one where you insert the "$" symbol, F4 on PCs. I can do this but I have to do it with the touch interface and it is not all that fast, is there a way to do that with the keyboard?

    - Another function I use a lot is the Autofill or fill which is really easy to do on a trackpad regular PC where you just double click or drag the corner of the cell. Problem is whn doing this on iPad I have to use the touch interface to select the command which is no problem, but the I can't apply the command with the keyboard I have to drag the cells touching the screen and that does not work very well, is there a way to do this witht the keyboard? If I select Fill function, the arrows appear and I can control cells with keyboard as usual but the function does not apply to other cells.
    This is the function: https://support.office.com/en-us/ar...n-or-row-96d97653-95d7-4980-9db1-d84bf4ceb0c5

    Sorry if this wasn't clear enough but I would really appreciate any kind of help regarding this issues.
    Thanks!!
     
  2. nalbagli thread starter macrumors 6502

    Joined:
    Sep 11, 2014
    #2
    Now I also have another issue with excel for my iPad on some of my worksheets whenever I change a number on a cell linked to others the other nombers don't change accordingly that means I have to go to formulas and press the calculator icon to manually tell excel to recalculate.

    Does anybody know where can I get support for this issues?
    --- Post Merged, Jan 4, 2016, Original Post Date: Jan 4, 2016 ---
    I tried contacting Microsoft Chat Support for this issue it was completeley useles the agent seemed to know less about Excel for iPad than I did. I hate this because I believe that if I can get used to excel I can make the iPad Pro my main working device
     

Share This Page