hidden data

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hidden data

Hidden data

resolvedResolved · Medium Priority · Version 2007

Angelika has attended:
Excel Intermediate course

Hidden data

How do you find data on a spreadsheet hidden by someone else

RE: 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


 

Excel tip:

Quick Absolute Cell References

When 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).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips


Server loaded in 0.07 secs.