Learn how to do basic LibreOffice Calc spreadsheet operations such as Add, Insert, Delete, etc.
Table of Contents
Basic Worksheet Operations
A new workbook contains only one Sheet named “Sheet1” in Calc by default.
To add a worksheet, Click on the small “+” sign at the bottom-left beside the first sheet. See below image.
After you click that, Sheet2 will be added.
Right-click on the Sheet name (e.g. Sheet1, Sheet2 etc.) and choose the option “Insert Sheet”. A new dialog would be opened, which contains various options for inserting a sheet.
- Choose “Before Current Sheet” if you want the new sheet to be inserted before the Sheet where you right-clicked.
- Choose “After Current Sheet” if you want the new sheet to be inserted after the Sheet where you right-clicked.
- If you want to insert only one Sheet, provide “No of sheets:” = 1 and choose a name.
- If you want to insert multiple sheets, provide “No of sheets:” = any number you want. Those many number of sheets would be inserted with names in numeric order – sheet3, sheet4, sheet5.
To delete a sheet, right-click on the sheet which you want to delete. In the context menu, choose “Delete Sheet”.
Choose Yes in the confirmation window.
To move or copy a sheet before or after an existing sheet OR move a sheet at the end of all the sheets, choose the option ‘Move/Copy Sheets’ by right-clicking on the sheet which you want to move/copy.
To move: Choose the option “Move” and choose where you want to move from the “Insert before” sheet list.
To copy: Choose the option “Copy” and choose where you want to move from the “Insert before” sheet list. While copying, you can also give a new name to the copied sheet from the “New Name” text box.
Right-click on the sheet which you want to rename and choose the option “Rename Sheet”.
A new pop-up will be open; give the new name and press OK.
Next Topic Split a Worksheet view.
Thanks for this interesting post, Keep Sharing.
Working LO 126.96.36.199 on Mac OS X 10.15.5;
Can’t insert a sheet- + doesn’t work, dialog grayed out,
What could be wrong here?
Found the issue — Protect spreadsheet structure was set.
There does nit seem to be an option to delete a hidden sheet anymore.
IWhen I right click on a sheet it doesn’t bring up a Content Menu with Delete sheet. Can’t figuree out how to delete the sheet