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!!
- 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!!