Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hidden data
Resolved · Medium Priority · Version 2007
Angelika has attended:
Excel Intermediate course
How do you find data on a spreadsheet hidden by someone else
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
|
Excel tip:Quick Absolute Cell ReferencesWhen entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs). |
We'll call during UK business hours
Server loaded in 0.07 secs.