Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to navigation Jump to search
Other languages:
English • ‎dansk • ‎français • ‎italiano • ‎čeština

How to insert a row into the first row before a matrix


A matrix begins on row 1 of a spreadsheet. Neither a right-click on the row header, nor the Insert menu allow me to insert a row before the matrix.

In the following example, the range A1:A3 contains the formula:

copie d'écran insertion ligne non disponible avant matrice
A1:A3 comprend une matrice


Put the cursor on the first row outside the matrix and use:

  • either the menu Insert ▸ Rows,
  • or right-click, then Insert ▸ Entire row.
copie d'écran insertion ligne disponible curseur dans la matrice
Cellule courante hors de la matrice