Password protect worksheets in Excel 2010 and Excel 2007

Excel 2010 and 2007 users can password protect their worksheets using the General Options

Listed below are the steps to password protect an Excel worksheet.

Click the File menu –> Save As option and click the tools dropdown arrow available on the bottom of the Save As dialog box

image

Select General Options form the menu list

image 

This would display the following General Options dialog box. Using the Password to open and Password to modify text fields you can specify the password required for opening or modifying an excel workbook.

image

After specifying the required passwords, click OK to confirm the changes.

Also See:Different ways to password protect worksheets in Excel 2013



Meet the Author

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

15 comments… add one

  • michelle Sep 8, 2010, 8:01 am

    We all know how to set passwords in microsoft office excel files but what about the case if you want to remove the current password and offer the file to everyone’s access. What’s worse,you forgot the Excel XLS files password,There are several password recovery softwares available online which can help you in removing the passwords but if you are searching the easy-to-use and quick one,then Excel password recovery 5.0 is your best choice,for further information

  • Vivian Mar 3, 2011, 6:24 am

    My excel worksheet doesnt indicate the General option as per the above. It only shows Map Network, Web option and compress picture. Please advise. TQ

  • robert Nov 26, 2011, 12:04 pm

    thanks its working

  • Glenn Dec 23, 2011, 6:55 pm

    I am looking to eliminate copying of an Excel file. People will be able to purchase a template, but I don’t want it copied and passed on for free. Any ideas?

  • Annabelle Jan 17, 2012, 9:38 pm

    Thanks very much! I’ve wasted around an hour a day for the last 2 days trying to find out how to do something as simple as password protect an Excel Document. Windows 2010 is the most useless, non sensical, pile of cr*p peice of software, which I’d never use except work have changed to this. URGH!

  • Simon Low May 3, 2012, 11:46 am

    My excel worksheet doesnt indicate the General option as per the above. It only shows Map Network, Web option and compress picture. Can someone help please. Thanks

  • jacque Jul 2, 2012, 2:09 pm

    very helpful thankyou

  • Benjamin Aug 26, 2012, 6:19 am

    How secure is this password protection, though?
    if my password is 15+ characters, is it still ‘recoverable’?

    How could I absolutely ensure that the data is secure?
    I know there is “no absolute” but I’m trying to get as close as possible.

  • Bill Sep 26, 2012, 10:01 am

    I’m using the free Windows Excel 2010 (internet Excel). It doesn’t show the “General” option. Is there an add-on that can be downloaded?

  • Steven Oct 3, 2012, 8:59 pm

    Suck it, byatches!

  • Glenn Oct 4, 2012, 12:16 am

    is there any way to have two passwords for a single Excel file? I would like my clients to create any PW they wish, but I also want a “master” PW that I can open any of the files.

    Does this exist?

  • su Oct 18, 2012, 10:17 pm

    Thank you so much, Ravi Shankar! I have been searching to find the right instructions for this. Great job!

  • Mark Dec 2, 2012, 7:24 pm

    My excel worksheet doesnt indicate the General option as per the above. It only shows Map Network, Web option and compress picture. Can someone help please. Thanks

  • Glen Dec 29, 2012, 3:45 am

    Thank you Ravi. I have been searching for these General Options for weeks now!

  • Karen Jan 2, 2013, 11:34 pm

    To password protect an Excel workbook in Excel 2010
    With the file open
    Click File
    Under Info – select Permissions (Protect Workbook)
    Select Encrypt with Password
    Enter your password twice

    Make sure you write it down. Can’t open if password is lost.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.