Advertisements

How to add or remove a password from your Microsoft Excel spreadsheets, to keep your data secure and private

  • 0

How to add or remove a password from your Microsoft Excel spreadsheets, to keep your data secure and private

Category : entrepreneur

  • You can add or remove a password from an Excel spreadsheet through the File tab.
  • Setting a password on your Excel spreadsheet is a great way to keep it secure, but can be annoying if you’re opening the same file often.
  • Adding or removing a password from your Excel spreadsheet is quick and easy, though the process varies slightly for Mac and PC users. 
  • Visit Business Insider’s homepage for more stories.

If you want your Microsoft Excel spreadsheet to have a little more protection, you can encrypt its data by setting a password. You can also remove the password at any time. 

Read on to learn how to set and remove a password from your Excel spreadsheet, on both PC and Mac.

Check out the products mentioned in this article:

Microsoft Office Home (From $139.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Microsoft Surface Pro 7 (From $1029 at Best Buy)

How to set a password to encrypt an Excel spreadsheet

On a PC

1. With your Excel spreadsheet open, click on the “File” tab, then click on “Info.”

2. Click on the box labeled “Protect Workbook” to open a drop-down menu. Then, click on “Encrypt with password” on the drop-down menu.

3. Type in the password that you want to use and click “OK.” You’ll be asked to reenter the password after this; do so and click “OK” again.

image 1

The password entry field will appear as a pop-up box on top of your Excel spreadsheet’s “Info” screen.
Chrissy Montelli/Business Insider

On a Mac

1. With a spreadsheet open, click “File” in the menu bar at the top of the screen.

2. Click “Passwords…”

Screen Shot 2019 11 22 at 3.23.36 PM

On a Mac, you’ll find the passwords in the “File” tab of the menu bar.
William Antonelli/Business Insider

3. You’ll be asked to set a password for opening the file, and another password for editing it. You can enter one, or both.

4. Once you click “OK,” you’ll be asked to re-enter the passwords that you chose. Click “OK” when you do so.

You will now be required to type in your password whenever you want to open this particular Excel spreadsheet. 

Make sure the password is something you can easily remember, or write it down in a safe place — there’s no password recovery option if you forget it.

How to remove a password to unencrypt an Excel spreadsheet

On a PC

1. Open your encrypted Excel spreadsheet, type in the password, and click “OK.”

image 2

Excel will require you to enter the spreadsheet’s password before you can view or edit the spreadsheet.
Chrissy Montelli/Business Insider

2. Click on the “File” tab, then click on “Info.”

3. Click on the box labeled “Protect Workbook” to open a drop-down menu. Then, click on “Encrypt with password” on the drop-down menu.

image 3

You will need to click on “Encrypt with password” to both set and remove passwords on Excel.
Chrissy Montelli/Business Insider

4. Delete the password that appears, so that the field is blank. Click “OK.”

On a Mac

1. Open your encrypted Excel file with the password you chose.

2. Click on “File” in your menu bar at the top of the screen.

3. Select “Passwords…”

4. You’ll be presented with the same menu that you chose your passwords in. Clear both text fields, and click “OK.”

Screen Shot 2019 11 22 at 3.23.50 PM

Delete both your passwords, and the encryption will be removed.
William Antonelli/Business Insider

Your Excel spreadsheet should no longer be password protected.

Related coverage from How To Do Everything: Tech:

  • How to remove duplicates in Microsoft Excel to clean up data in individual or multiple columns

  • How to add a column in Microsoft Excel in 2 different ways

  • How to hide and unhide columns in Excel to optimize your work in a spreadsheet

  • How to make a pie chart from your spreadsheet data in Microsoft Excel in 5 easy steps

  • How to insert multiple rows in Microsoft Excel on your Mac or PC

Advertisements

About Author

Sammy Singh

Global VC, Founder, and entrepreneur extraordinaire as featured in Inc. Magazine, Bloomberg, and Forbes. Sammy Singh is a graduate of UCLA and Wharton School of Business as well as a former student of Loyola University of Chicago. Sammy is best known as a renowned financial technology global entrepreneur and has founded over 26 different firms across industry and all over the world. He is a venture capitalist,a TV/ Film actor, tax specialist, and marketing solutions strategist. Connect with Sammy Singh on social media below! www.linkedin.com/in/cfo www.instagram.com/champagnegqpapi www.facebook.com/officialsammysingh www.twitter.com/cxosynergy www.medium.com/@sammysingh www.crunchbase.com/sammysingh

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.