Hiding items

Dear Lee

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

Once the worksheet is protected the rows and columns by default are protected which means they cannot be deleted, inserted or the user cannot hide or unhide them.

But even when the worksheet is protected user can hide, unhide, delete, rename, etc... worksheets.

In order for protecting your worksheets from the above mentioned changes you need to choose Protect Workbook in the Review Tab. The password is optional but is recommended.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007