Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How many ways are there to password protect an excel file at the user level. Is there a way for a user to specify edit access via a password?

share|improve this question

migrated from stackoverflow.com Oct 19 '10 at 15:11

This question came from our site for professional and enthusiast programmers.

add comment

3 Answers

When you save the Excel File, there should be an Options button in the dialog that allows you to specify a password to open, and a password to modify.

If you wish only to lock certain cells of a spreadsheet. check out Tools -> Protection -> Protect Sheet. Protect Sheet will lock any cells that are marked as Locked in the Format Cells dialog.

share|improve this answer
    
Thanks this is what i was trying to remember –  Craig G Jan 7 '09 at 17:53
    
You should mark this as the answer then. –  qroberts Oct 19 '10 at 18:24
add comment

In Excel 2003, you can perform various types of password locking using the items under Tools | Protection. In particular, you can allow edit access to only certain ranges of cells using the Allow Users to Edit Ranges... item.

share|improve this answer
add comment

First of all, it would be good if you could clarify why you would want to protect the file. The reason I'm asking this is because if the file can be read, it can always, in a sense, be modified. If you can read the entire file, that means you can copy it, and that means you can modify the copy as a new file.

If your goal here is to protect the Excel sheet from prying eyes, you should look into file encryption in general instead. You could zip it using 7zip and set a password, which encrypts the file, for example.

If you just want to password protect your Excel sheets, know that the goal of this is:

To prevent a user from accidentally or deliberately changing, moving, or deleting important data from a worksheet or workbook

The goal is not to protect the data itself from other people. Just wanted to clarify.

share|improve this answer
add comment

protected by Community Jan 31 '13 at 12:56

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?