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.