HAN.xlsx [Read-Only] - Excel at Microsoft Excel!
Home
Introduction
Excel
101
So, you're new to spreadsheet huh.. Check this out!
Excel
Formula
How to write an excel formula!
New Posts
Love
Meter
Who is Your Crush's Big Time Crush?
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Projects
Gag
Love
Meter
Who is Your Crush's Big Time Crush?
Other
Gag
Coming soon!
Social Network
Excel
Facebook
Coming soon!
Excel
Twitter
Coming soon!
Games
Formulas
Financial Modeling
Developer
Passwords
Password Recovery
Unprotect
Sheet
Remove password from protected worksheets and workbooks!
Dictionary
Attack
Open password-protected excel file using a dictionary attack!
Brute-force
Attack
Learn how to open password protected Excel File! Coming soon!
About
HANxlsx
About
Me
A little intro..
Privacy
Policy
Privacy Policy!
Disclaimer
Disclaimer!

[back to top!]

Coming up next!

Chatting and updating status using excel spreadsheet like a boss!

Our next excel project is to create a facebook-like excel spreadsheet that works like facebook. You don't say.. :D

Stay tuned, people! More cool stuff is coming!

Sunday, October 28, 2012

Excel Basics: Protecting Your Worksheet and Workbook

This post will show you how to protect worksheets from editing and restricting access to worksheets via passwords. Also, it is useful to protect some of the cells in a spreadsheet to avoid accidentally overwriting data we need to keep.
But, please keep in mind that there is no 100% guarantee that your worksheet is untouchable and safe. I will post a tutorial in the Excel Advanced section on how the worksheet password works and how to break it, later.

Stay tuned people!




To protect a worksheet from being edited:
-  Click on the worksheet you want to protect;
-  Select “Review” --> ”Protect sheet”;
-  Enter your password;
-  “Save


The sheet now can be opened but not edited unless the password is entered to unprotect sheet.

To protect a workbook from being edited:
-  Click on the Microsoft Office Button, Oh which one is it? See this this post.
-  Click on “Save As
-  Choose “Excel Workbook
-  At the bottom of the screen, click on “Tools, General Options
-  Enter your password for the workbook.
-  Click “Ok”.



The workbook now cannot be opened unless the correct password is entered.