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?
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
