Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
excel+courses - protection

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Protection

excel+courses - Protection

ResolvedVersion Standard

Roxanne has attended:
Excel Intermediate course

Protection

How would I protect a spreadsheet so that only I could delete but others can modify?

RE: Protection

Hi Roxanne,

Thank you for your question.

To protect a worksheet:

    1. Highlight all numbers
    2. Select FORMAT menu -> Cells -> Protection
    3. Uncheck box LOCKED -> Press OK
    4. select TOOLS menu -> Protection -> Protect Sheet
    5. Set a password & confirm the password
    6. Press OK


Hope this is useful.

Regards,

Katie

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.