Jul 19, 2016
If you have any private or confidential information inside a particular section, then you can also password protect it to ensure only the person with a password may open that section.
First right click on the “Section” which you would like to password protect, and then click “Password Protect This Section” in the context menu.
Now click on “Set Password…” and provide the password you want to add. You can change or remove the password by going to the same option again and click on “Change Password” or “Remove Password” .
How do your Excel skills stack up?
Test NowNext up:
- Managing for excellence: An innovative approach to managing performance
- How-to: Give access to a list only in SharePoint 2013
- PowerShell Basics Series – Manipulating strings
- Formula vs. measure in PowerPivot
- PhotoShop in action - Part 1
- Stop whinging; it’s boring!
- Windows Store for Business
- Create with Adobe’s Capture Mobile app: Creating Brushes
- Quick Tuts: Excel 2010 - vLookups simplified
- Social tagging in SharePoint 2010
Previously
- SharePoint 2016 social features
- 5 posts to help you become a better communicator
- How to omit dates in an Excel chart axis
- PowerShell Basics Series – Measuring objects (Part 2)
- Create cascaded drop-downs in Microsoft Access forms
- Working with Styles - Part 2
- What is Continual Service Improvement (CSI)?
- Honesty at work
- Search for a Worksheet Function in Excel
- Providing feedback for user interactions