98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to hide certain columns for certain users on Excel
How to hide certain columns for certain users on Excel
Resolved · Urgent Priority · Version 2013
Wed 9 Jul 2014, 11:46Delegate 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:47Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Saving your Excel Spreadsheet as a CSV FileIn situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps. |
