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.
Add
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.
Insert
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.
Position:
- 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.
Sheet:
- 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.
Delete
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.
Move/Copy
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.
Rename
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.