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 Formeln und Funktionen in einer Tabelle verwenden.
If a cell does not keep what you typed, Support kontaktieren.
Den Magpie-Support fragen
Senden Sie dem Magpie-Team eine Frage zu allem, was dieser Artikel nicht beantwortet.