Frequently asked questions - Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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}
Solution
Put the cursor on the first row outside the matrix and use:
- either the menu ▸ ,
- or right-click, then ▸ .