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

17900 views
4

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.

add-sheet-sign

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.

insert-sheet-menu
insert-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”.

delete-sheet

Choose Yes in the confirmation window.

delete-sheet-confirmation

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.

move-copy-sheet

To move: Choose the option “Move” and choose where you want to move from the “Insert before” sheet list.

move-sheet

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.

copy-sheet

Rename

Right-click on the sheet which you want to rename and choose the option “Rename Sheet”.

rename-sheet

A new pop-up will be open; give the new name and press OK.

rename-sheet-new-name

Next Topic  Split a Worksheet view.

Next Chapter  Formatting Cells

Join our Telegram channel and stay informed on the move.

arindam

Creator of libreofficehelp.com. The aim is to help as many people as possible with easy-to-understand tutorials. Connect with me via Telegram, Twitter, LinkedIn, or send us an email.

Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

4 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
primarylearning

Thanks for this interesting post, Keep Sharing.

Rob

Working LO 6.3.6.2 on Mac OS X 10.15.5;

Can’t insert a sheet- + doesn’t work, dialog grayed out,

What could be wrong here?

Rob

Found the issue — Protect spreadsheet structure was set.

wsanders

There does nit seem to be an option to delete a hidden sheet anymore.