Hidden data

Dear Angelika

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

It is important to understand that if the user has hidden the data and then protected the worksheet with a password then you cannot view the hidden data (this could be hidden rows/columns/workseets/formulae/functions, etc...) unless you have the password.

Sometimes when you protect worksheet you can allow the other people to make certian ammendments such as inserting, deleting rows or columns or do formatting on the cells. etc... This depends upon the discretion of the person who the speardsheet originally belongs to.

I hope this helps in answering your query.

Please mark this post as resolved if you are happy with the answer!!

Many thanks

Kindest Regards

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