How to use Delete Sheet to remove an obsolete worksheet from a workbook?
its Thank you for your feedback. Just turned to my computer and attempted to follow your instructions meticulously.
While having moved my cursor to a cell on the sheet I want deleted, I went to the drop-down list of commands under the Sheet heading, and observe that it is grey, unlike all of the commands that are full black. So. when I followed your advice , pointed my mouse on Delete Sheet and clicked, nothing whatsoever happened.
My notebook’s environment is MS Windows 11 and no other MS product at all. By year-end, the present computer will be superseded by a Dell Technologies workbook. I have ordered Linux as its operating syste, since my Christmas gift to me, is to as substantially as possible, remove myself from any type of MS control over my work.
So forget Windows 11, think only Linux. What might work with Calc, do you think? to satisfactorily perform the task I wish, to actually delete obsolete worksheets from my workbook.
Thankyou for yyour assistance. Merry Christmas and Happy New Year to you and your family …
David A. Swan, President and Chief Energy Officer
emPowerGHG Business Corp.
and
eco-Options Energy Cooperative
For your background reading on my business initiative, requiring at a minimum, only branch-level services, at which BMO has successfully performed, since 1807
Hi, @DAS_eco-Options , se planilha com senha, nĂŁo Ă© permitido excluir.
Hi, @DAS_eco-Options , if spreadsheet with password, deleting is not allowed.
1 Like
I work alone, I live alone, since 2010. I do not believe I used password protection on my own spreadsheet, but will check it out.
But even before I get to that stage, the selection Delete Sheet, is grey. I’ll let you know what I discover.
As per the Calc Manual and your instructions, I saved the Calc file with a new name, and specifically unchecked the box to apply a password
Insofar as I know, there is no password applied to this workbook.
However the monitor display of the Delete Sheet Command is still gray. NOT black
My workbook is about to transition into production mode. Iwant to remove 10-12 worksheets used for concept development, now unused.
What do you suggest? Thank you for your help!
Best DAS
menu:Tools>Protect sheet protects sheet contents and the protected sheet from being renamed or removed.
menu:Tools>Protect spreadsheet structure protects all sheets from being renamed, moved, removed.