Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Essential Excel Skills: Protecting an Excel Worksheet

August 17, 2016 by Tyrone Pernsley

Protecting an Excel WorksheetThere are various skills everyone should learn in Excel. One of those skills is protecting an Excel worksheet. Excel allows you to add protection to a worksheet or workbook to prevent other users from making changes to your worksheet. This is particularly useful when you have an Excel workbook that multiple people use at your company.

Protecting an Excel worksheet is fairly straightforward.

Here is what you need to do:

  • Right click on the sheet tab to open the menu
  • Select Protect Worksheet
  • Set your password
  • Select the individual items you want to limit
  • Click Okay
  • Re-enter your password

Here is a quick demonstration:

Protecting an Excel Worksheet

There are several reasons to protect a worksheet. Let’s say you have a weekly sales log that has formulas and functions built into. You want your sales team to add information but don’t want them changing formulas – on accident or on purpose. So, you add protection to prevent them from being able to change anything.

Even for something as simple as not wanting someone to change your formatting, protecting an Excel worksheet can come in handy.

We here a Learn Excel Now hope you now feel comfortable protecting an Excel worksheet. This essential Excel skill will help in ensuring your data is always what you expect it to be.

Like Learn Excel Now? Follow us on social media and share our content with your networks! And don’t forget to sign up for the Newsletter

Kevin – Learn Excel Now

Filed Under: Formatting Tagged With: Excel 2013, formatting, protecting an excel worksheet

Keep up to date on all the newest live trainings, events, and tutorials.

Comments

  1. Flora Digby says

    August 17, 2016 at 3:24 pm

    Very useful tool for working with sensitive information. How do you retrieve a lost password on a protected file?

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2020 ­ Learn Excel Now

Copyright © 2021 · News Pro Theme on Genesis Framework · WordPress · Log in