Ask Your Question

Why is there not a delete option in sheets for officelibre calc??

asked 2019-05-03 17:40:09 +0200

BAMBI gravatar image

updated 2020-09-03 13:37:53 +0200

Alex Kemp gravatar image

No delete option or copy move or copy sheet!

edit retag flag offensive close merge delete


I know this sounds crazy but there is NOT that option any longer. These options, images that you displayed were there as of 2 days ago. I came in yesterday and it was missing. I restarted the computer thinking it could be like our phones. And STILL nothing. The delete and move/copy sheet option are gone.

BAMBI gravatar imageBAMBI ( 2019-05-03 18:33:12 +0200 )edit

This sounds really weird - which OS are you using and which LibreOffice Verision? May be you need give

  • Resetting your user profile as per FAQ
  • Reinstalling you LibreOffice

a try.

Opaque gravatar imageOpaque ( 2019-05-03 18:45:59 +0200 )edit

Have you customized your menu's? If yes - Go to Tools -> Customize -> Tab: Context Menus Select Sheet Tabs Bar in category Taget and click to Defaults

Opaque gravatar imageOpaque ( 2019-05-03 19:07:31 +0200 )edit

I have looked to customize, yes. And it was already set in there as if it always has been. 6.1.5 is what I am using. I think I canceled my other comment. Sorry! I replied back with... I have one spreadsheet that has BOTH the options in the sheet tab, I have one spreadsheet that has ONE option in the sheet tab, being (move/copy). And ONE spreadsheet, my everyday use one, the one a I am referring to that does NOT have the options.

BAMBI gravatar imageBAMBI ( 2019-05-03 19:12:42 +0200 )edit

I've never had an issue like this in my years of Office Admin work. But have never used LibreOffice either. When I was hire on here everything had been done by paper ledger since 1955 hahahahahahaha... I started here 3 months ago. Also when given the computer, windows 8 I was not able to download excel. Because microsoft office had not been installed. Which they thought had been when buying and setting up the computer to begin with?? Soooooo I was left with LibreOffice (being free and all)

BAMBI gravatar imageBAMBI ( 2019-05-03 19:16:13 +0200 )edit

If there is only 1 Sheet in a LibreOffice file, then there is no "Delete" option, since you cannot delete the one and only sheet.

Opaque gravatar imageOpaque ( 2019-05-03 19:23:10 +0200 )edit

One spreadsheet has approx 25 sheets (no options) One spreadsheet has approx 10 sheets with (both options) One spreadsheet has 3 sheets (one option)

BAMBI gravatar imageBAMBI ( 2019-05-03 19:27:22 +0200 )edit

Did you follow my advice above? And which file format are you using (hopefully .ods ?)

Opaque gravatar imageOpaque ( 2019-05-03 19:33:23 +0200 )edit

Yes I did.. except the reinstalling part. If I do that will all my work be deleted?

BAMBI gravatar imageBAMBI ( 2019-05-03 19:34:54 +0200 )edit

I've meant the

Go to Tools -> Customize -> Tab: Context Menus Select Sheet Tabs Bar in category Taget and click to Defaults

part. It may be that the customized settings are stored within the respective file and thus resetting the user profile will have no effect,

Opaque gravatar imageOpaque ( 2019-05-03 19:39:17 +0200 )edit

4 Answers

Sort by » oldest newest most voted

answered 2019-05-03 17:54:36 +0200

Opaque gravatar image

updated 2020-12-03 20:06:09 +0200

Hello, may be I didn't get you right but all is there - just right click on the sheet name and you get a context menu.

image description

Second option:

Go to Sheet in menu and you also will find Delete Sheet and/or Move or Copy Sheet... and Rename Sheet

Third option:

If you can't delete or move sheets, then Tools -> Protect Spreadsheet Structure... might be enabled.

edit flag offensive delete link more

answered 2020-10-23 13:36:17 +0200

Tomaz Pessanha gravatar image

Not sure if still an issue ... Check if you have Recording mode active. This will disable delete/copy worksheet commands

edit flag offensive delete link more

answered 2020-12-15 21:32:22 +0200

Tomaz actually already said this, but I know I missed it the first time I read through.

"tracking changes" can make the delete sheet disappear from the sheet right click, and grey out in the Sheet menu, as in saochen's screenshots.

I'm sure I had never turned it on, but, somehow it was on and that was what was creating this problem.

image description

edit flag offensive delete link more

answered 2020-12-03 20:00:10 +0200

I'm having the same issue. The last time I use Libre Office Calc about a week ago I was able to delete, move and copy sheets and now I either don't have that option in the contextual menu or it is greyed out under the sheets tab.

image description image description

Thank you;


edit flag offensive delete link more


This doesn't answer the question but if you can't delete or move sheets, then Tools -> Protect Spreadsheet Structure... might be enabled.

Opaque gravatar imageOpaque ( 2020-12-03 20:02:11 +0200 )edit

It does not look like it is on. And I have not turned it on (I'm the only one that uses this computer and spreadsheet. When I go there it asks me to create a password to turn it on.

sacohen gravatar imagesacohen ( 2020-12-03 20:10:54 +0200 )edit

So what can I do to fix this?

sacohen gravatar imagesacohen ( 2020-12-08 00:41:42 +0200 )edit

When I go there it asks me to create a password to turn it on.

From my perspective the Spreadsheet Structure is protected and you need a password to unprotect it. But I don't have your sheet so I cannot verify. Hence I cannot further help unless I could investigate the file.

Opaque gravatar imageOpaque ( 2020-12-08 00:48:23 +0200 )edit

I have never set up a password on this spreadsheet. I didn't even know that Spreadsheet Structure was an option and under Tools>Protect. How would this have gotten turned on if no one but me uses the computer or the spreadsheet?

sacohen gravatar imagesacohen ( 2020-12-08 01:08:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-05-03 17:40:09 +0200

Seen: 1,515 times

Last updated: Dec 15 '20