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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hiding comments

Hiding comments

ResolvedVersion 2003

Wed 2 Sep 2009, 09:28 Delegate Liz said...

Liz has attended:
Excel Intermediate course

Hiding comments

Is it possible to hide comments in a password-protected document?

Wed 2 Sep 2009, 13:38 Trainer Amanda said...

RE: Hiding comments

Hello Liz

Thank you for your question and welcome to the forum.

It appears that even when you apply protection to an Excel file, there are still ways of being able to see comments in the spreadsheet.

So I would suggest either making a copy of the spreadsheet and removing the comments and allow people to view this copy of the spreadsheet; or I think making a PDF of the spreadsheet would stop people being able to view the comments.

Kind regards
Amanda

Wed 9 Sep 2009, 14:05 Delegate Liz said...

RE: Hiding comments

Thank you

Wed 9 Sep 2009: Automatically marked as resolved.

Excel tip:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Hiding comments

Hiding comments

RE: Hiding comments

RE: Hiding comments

Excel articles

Excel tip:

Formst Excel to display leading zeroes