Does anyone know how to get rid of an obsolete sheet in an Excel spreadsheet? I have followed the instructions given by the Help document but they don't work--the sheets are still there. They aren't "wrong" but they are no longer needed and are in the way of the sheets that are essential. (I've tried to move them out of the way, and that hasn't worked, either.)

Never mind. I discovered that the Workbook was protected and I've successfully eliminated the obsolete sheets. I created the original spreadsheet many years ago and apparently forgot that I'd protected its structure.

flashguy

Do you mean the tabs you can name at bottom of worksheets, but in same file?

To answer your question, right click on the sheet tab, click on delete.

But to avoid problems, be sure none of the data in the sheet you will delete is referenced by a formula in another sheet.

Thank you. Yes, I was referring to the tabs at the bottom. The obsolete sheets were charts of intermediate work values and only useful during the initial creation cycle. No important data was eliminated by deleting them.

I've been protecting and unprotecting the individual sheets all the time, but just forgot that I'd also protected the structure in the early years. That protection is still necessary, and I have reapplied it now that the obsolete sheets are gone.

flashguy