Add, Insert, Delete, Copy, Move, Rename a Worksheet in LibreOffice Calc

Learn how to do basic LibreOffice Calc spreadsheet operations such as Add, Insert, Delete, etc.

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.

Next Chapter  Formatting Cells