Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

unprotecting spreadsheet

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Unprotecting a spreadsheet

Unprotecting a spreadsheet

ResolvedVersion 2003

Dee has attended:
Excel Advanced course
Excel Intermediate course

Unprotecting a spreadsheet

I am working with a large spreadsheet that at one point I must have protected in some way, as I am not allowed to delete four of the worksheets. I don't remember what exactly I did, as it was quite some time ago. The sheets really do need to be deleted.

Is there a limit to the number of sheets that you can have for a single Excel page? I don't know if its related to my problem with not being able to delete the worksheets or not, but when I go to the Insert (at the top) and look to add a worksheet, it is not available as an option (grey instead of black).

Any advice?

Cheers,

Dee

RE: Unprotecting a spreadsheet

Hi Dee

Thank you for your question

For starters, click on the tools menu and select protection. If you have protected it, then you will be given the option to unprotect the workbook.Select this (Entering any required password) and you should be fine.

If this is not the case, let me know and I will explore other options

Regards

Stephen

RE: Unprotecting a spreadsheet

Thanks Stephen, it worked a treat!

Dee

Excel tip:

Create Charts with One keystroke

Create a graph with one click

1. Select your data.
2. Press F11.
3. You have a graph.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.