Protection

Resolved · Medium Priority · Version 2010

Thu 27 Oct 2016, 16:44 Delegate Kati said...

Kati has attended:
Excel Intermediate course
Excel Advanced course

Protection

Is it possible for an external user to view a sheet but only certain data. For example, if they have a profile they can fill in their personal details but on a seperate table there will be a feedback page which they are not meant to see?

Fri 28 Oct 2016, 13:30 Trainer Jens said...

RE: Protection

Hi Kati,

Thank you for the forum question.

If you want to keep someone from been able to see part of a worksheet, you hide the columns and then protect the sheet with a password.

Change column width to zero and the click Protect Sheet on the Review tab. Add a password and click ok.

Please let me know if this is not what you want.

Kind regards

Jens Bonde
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

Fri 4 Nov 2016: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips