Hiding comments

Resolved · Low Priority · Version 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:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips

Hiding comments

Hiding comments

RE: Hiding comments

RE: Hiding comments

Excel articles

Excel tip:

Hide separate columns in Excel 2010