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 Utiliser des formules et des fonctions dans un tableur.

If a cell does not keep what you typed, Contacter l’assistance.

Demander à l’assistance Magpie

Envoyez à l’équipe Magpie une question sur tout ce que cet article n’explique pas.