password protection

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

Train Strikes - 7th, 12th Nov 2024

Hide

Contact Us About Resources Sign in

Solutions Through Learning

Excellent

Request Callback We will call you back 0207 987 3777 Call for assistance Your Basket Basket is empty

Solutions Through Learning

Callback

Sign in

Basket

Menu

Call us on 0207 987 3777 or Search our website

Courses
- Application Training
  - Excel
    - All Excel
    - Introduction
    - Intermediate
    - Advanced
    - Advanced - Formulas & Functions
    - Advanced - For Power Users
    - VBA
    - VBA Introduction
    - VBA Intermediate
    - VBA Advanced
    - Charting
    - Dashboards for Business Intelligence
    - Advanced Excel Dashboards
    - Forecasting & Data Analysis
    - Power Query
    - PivotTables
    - PowerPivot
    - Financial Modelling
    - Excel for Finance Professionals
  - Microsoft Office 365
    - 365 Adoption Program
    - 365 Explained
    - 365 Ambassadors
    - 365 End Users
    - OneNote
    - Teams
  - ChatGPT
  - Power Automate
  - Power BI
  - Powerpoint
  - Access
  - Word
  - MS Project
  - Sharepoint
  - Outlook
  - Visio
  - View all 200+ Courses
- Productivity Training Programs
- Professional Development
  - All Professional Development
  - Taking Minutes
  - Time Management
  - Organisational Skills
  - Negotiating Skills
  - Presentation Skills
  - Effective Communication Skills
  - Assertiveness At Work
  - View all 50+ Courses
- Management Training
  - All Management Training
  - Introduction to Management
  - Managing Teams Remotely
  - Mentoring
  - Managing Change
  - Leadership Development
  - View all 50+ courses
- Sales & Customer Service
  - All Sales & Customer Service
  - Customer Service Excellence
  - Excellent Account Management
  - Fundamentals of Selling
  - Selling Skills Programme
  - View all 20+ courses
- Financial Training
  - All Financial Training
  - Finance for Non Financial Managers
  - Effective Budgeting and Beyond
  - View all Courses
- Project Management
  - All Project Management
  - Project Management course
  - Microsoft Project
  - PRINCE 2 Foundation
  - PRINCE 2 Practitioner
  - View all 18+ courses
- eLearning Solutions
Promotions
- Promotions
- Excel Courses London
Schedule
- Public Schedule
- How to Book
- Reschedule
- Last Minute Deals
- What to Expect
- Venues and Equipment Hire
- Industry Leading Pricing model
Formats
- All Formats
- Public Scheduled Courses
- On-Site Training
- Productivity Training Programs
- Closed Company Events
- Online Classroom (Virtual)
- Consultancy
- One to One Training
- Training Needs Analysis
- Floor Walking
- Roll Out
- E Learning
- Executive Coaching
Our Clients
- Client List
- Online Reviews
- Client Testimonials
- Client Feedback
- Featured Case Studies
Contact Us
About us
Resources
Your account
Sign in

Home » Resources » Forum

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Password protection

Password protection

Resolved · Medium Priority · Version 2003

Tue 6 Oct 2009, 16:23 Delegate Kaylea said...

Kaylea has attended:
Excel Advanced course

Password protection

How to password protect a sheet, not the whole workbook?

Wed 7 Oct 2009, 16:35 Trainer Simon said...

RE: Password protection

Hi Kaylea,

Thank you for your question.

If you want to protect a sheet go to Tools, Protection and then Protect sheet.

Type a password in and then confirm the password after clicking OK.

The whole sheet is now protected so no changes can be made to any of the cells unless they know the password to unprotect the sheet.

I hope this answers your question.

Regards

Simon