Enter values and select cells
Type into a cell, change what a cell holds, move and select with the keyboard, go to a cell by its address, and use the formula bar.
Click a cell and type to replace its contents. Press Enter to finish and move down.
Change what a cell holds
- Double-click a cell, or press Enter or F2 on it, to change what is already there.
- Press Esc to cancel the edit.
- Press Shift+Enter to start a new line in a cell's text. The cell then wraps so every line shows.
- Press Delete to clear the selected cells without removing their rows or columns.
Move and select
- Use the arrow keys to move.
- Hold Shift with an arrow key to extend a selection.
- Press Tab or Shift+Tab to move along a row.
Go to a cell
The box above the grid shows the selected cell's address, such as A1. Type an
address or a named range in the box and press Enter to go to it.
The formula bar
The formula bar beside the address box shows a cell's formula rather than its result. Type in the formula bar and press Enter, or click another cell or press Tab: either way the text is saved in the cell you were typing for. Esc leaves the cell as it was.
Formulas and functions are in Use formulas and functions in a spreadsheet.
If a cell does not keep what you typed, Contact support.
Ask Magpie support
Send Magpie staff a question about anything this article does not answer.