To edit text in a cell:
- Tap the pencil icon in the top toolbar to access Edit mode.
- Select the cell and tap the formula text field, or double-tap the cell to begin editing.
- Double-tap text in the formula text field to: select text, cut, copy, or paste.
To insert a formula:
- Select a cell, and tap the “Formulas” button to insert a formula into that cell.
- Choose a category of formulae and then select the desired formula. Formulae may also be entered manually via typing while editing a cell.
- The formula will then appear in the formula text field along with a preview showing the arguments for that particular formula (some or all may be required; refer to Excel help for more information on formulas). The current argument will be highlighted and underlined in the popup to show which part of the formula is being edited.
- While editing a formula, tap a cell in the grid to input a reference to that cell in the formula. Double-tap and drag to selection a region of cells to use in a formula (the selected region will appear red while being selected).
- When formula or cell editing is complete, tap the check mark next to the formula bar or press the “Return” key on the iOS keyboard to save changes to the cell.