98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hiding Worksheets
Hiding Worksheets
Resolved · Low Priority · Version 2003
Mon 9 Nov 2009, 13:04Delegate Margarida said...
Margarida has attended:
Excel Advanced course
Hiding Worksheets
Hi
Is it possible to ‘hide’ certain worksheets? For example if I were to present some data to a client I may have a front page summary showing the headlines but also have another worksheet used to make the calculations. How would I hide the calculations worksheet if I do not wish this to be seen by the client?
Many thanks
Margarida
Mon 9 Nov 2009, 14:00Trainer Simon said...
RE: Hiding Worksheets
Hi Margarida,
Thank you for your question and welcome to the forum.
Open your spreadsheet and select the sheet you want hidden. Then go to Format, Sheet and Hide.
Then protect the workbook using Tools, Protection and then Protect Workbook. Type in a password, re-enter it and click ok. The other person will not be able to unhide the sheet without the password.
This should work and resolve your problem. I suggest you try it first and make sure you are happy it will resolve your question.
I hope this answers your question.
Regards
Simon
Mon 16 Nov 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Excel's MODE functionUse Excel's MODE function to display the most common value present in a particular range of cells. |
