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

hiding worksheets

ResolvedVersion 2003

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

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.

Excel tip:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.