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

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 clicked that, Sheet2 would be added.

Insert

Right click on the Sheet name (e.g. Sheet1, Sheet2 etc) and choose option “Insert Sheet”. A new dialog would be opened which contains various options of inserting 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 sheet, 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 option ‘Move/Copy Sheets’ by right clicking on the sheet which you want to move/copy.

move-copy-sheet

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

move-sheet

 

To copy: Choose option “Copy” and choose where you want to move from “Insert before” sheet list. While copying you can also give new name to the copied sheet from “New Name” text box.

copy-sheet

Rename

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

rename-sheet

A new pop-up would be open, give the new name and press OK.

rename-sheet-new-name

 

Next Topic  Split a Worksheet view.

Next Chapter  Formatting Cells

Leave a Reply

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

One thought on “Add, Insert, Delete, Copy, Move, Rename a Worksheet in LibreOffice Calc”