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 » Insert Comments

Insert Comments

ResolvedVersion 2010

Thu 15 Aug 2013, 16:26 Delegate Maria said...

Maria has attended:
Excel Advanced - Formulas & Functions course

Insert Comments

send a spreadsheet out with Insert Comments and to make no visible those to other people

Mon 19 Aug 2013, 09:02 Trainer Gary said...

RE: Insert Comments

Hi Maria

Thanks for getting in touch. I'm not sure it's possible to have comments in a worksheet and not have them visible.

Perhaps have comments on a hidden sheet within the workbook?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 26 Aug 2013: Automatically marked as resolved.

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Insert Comments

Insert Comments

RE: Insert Comments

Excel articles

Excel tip:

Create a unique items table from a duplicating table