I have been trying everything in the last couple of weeks to completely delete sheet 1 of a spreadsheet that I created a few months ago. I deleted it, so I thought, however, it keeps showing up and printing when I try to print my new spreadsheet. I deleted it from LibreOffice, cleaned out my temp files, I’ve done everything suggested, but it still shows up. How can I completely delete this sheet? I really need to get my new sheet printed.
Very strange. Open an empty document and, select all the sheets in the source document, then right-click and select Move or Copy Sheet, then select the destination document. Your ghost sheet should disappear this way.
Note: if your Sheet1 appears each time you open a new document, it means that it was saved in the default template. Then do the following (from LibreOffice official guide):
To re-enable LibreOffice’s default spreadsheet template as the default: 1) In the Template Management dialog, click any folder in the box on the left. 2) Click the Commands button and choose Reset Default Template → Spreadsheet from the drop-down menu. The next time that you create a spreadsheet by choosing File → New, it will be created from LibreOffice’s default template for spreadsheets.
If you click Sheet > Show, does the dialogue show Sheet 1 as a hidden sheet? If so, then click OK to show it and then click Sheet > Delete sheet