Frequently asked questions - Calc

    From The Document Foundation Wiki
    < Faq‎ | Calc


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

    Context

    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:

    {=B1:B3}
    copie d'écran insertion ligne non disponible avant matrice
    A1:A3 comprend une matrice


    Solution

    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