Insert Multiple Rows in Calc or Excel

Inserting Rows in Calc or Excel Spreadsheet

To insert multiple blank rows in LibreOffice's spreadsheet program Calc, immediately underneath the point where you wish to insert the rows use shift-click to select the number of rows you wish to insert, whether they have content or not, and then right-click on the numbered column on the far left and select Insert Rows Above.

To insert even more rows, using the repeat/redo keyboard shortcut Ctrl+Y may be helpful.