Freeze, group, insert and delete rows and columns
Keep rows or columns in view while you scroll, insert and delete rows and columns, and group rows or columns so they can be collapsed.
Freeze rows or columns
- Select a cell. To freeze the top row, select a cell in row 1.
- Choose Rows and columns → Freeze through selected row or Freeze through selected column.
The rows above, or the columns to the left, then stay in view while you scroll. Unfreeze panes removes both.
Insert and delete rows and columns
Insert row above, Insert column left, Delete row and Delete column act on the selected rows or columns. Formulas keep pointing at the same cells when rows and columns move.
Group rows or columns
- Select two or more rows or columns.
- Choose Group rows or Group columns.
- Collapse group hides the grouped rows or columns without deleting them.
- Expand groups shows them.
- Ungroup removes the smallest group in the selection.
Groups can be nested.
If rows or columns do not freeze, group or move as described, Support kontaktieren.
Den Magpie-Support fragen
Senden Sie dem Magpie-Team eine Frage zu allem, was dieser Artikel nicht beantwortet.