How to hide certain columns for certain users on Excel

Resolved · Urgent Priority · Version 2013

Wed 9 Jul 2014, 11:46 Delegate Siobhan said...

Siobhan has attended:
Excel Intermediate course
Excel Advanced course
Project Management - Framework & Processes course
PowerPoint Intermediate Advanced course

How to hide certain columns for certain users on Excel

In a shared workbook how would you make a column hidden and not viewable to certain users whilst still making it accessible for the other users to view and edit it?

Thu 10 Jul 2014, 12:47 Trainer Gary said...

RE: How to hide certain columns for certain users on Excel

Hi Siobhan

Thanks for getting in touch. There isn't a straightforward solution, but there are options.

One workaround might be to unshare the work book, hide (or unhide columns), lock (with password) and reshare - giving those people who need to edit the workbook the password.

To protect your sheet, go to Review > Protect Sheet. You can add a password to this dialogue box.

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Saving your Excel Spreadsheet as a CSV File

In situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps.

Click the File tab and click Save As.
Enter a name in the File name field.
Click the drop-down arrow next to the Save as type field to select the file type. Scroll down the list and select CSV (comma delimited) (*.CSV)
Click Save

The data will now be saved to a separate CSV file which can be used in different applications.

View all Excel hints and tips