how to make an excel spreadsheet password protected

Picking Sheet will protect the entire file, while picking Range will require you to select the cells you want to protect from modification. Now you can choose what part of the worksheet you want to protect. From there, click on Protected sheets and ranges. From the drop-down menus near the top of the screen, click on Data. Open up the sheet file you want to protect. People will still be able to copy and paste information from the file - they just won’t be able to change anything. Due to how Google Drive works, you will have to provide the file yourself and alter permissions for others to view it. Unfortunately, the only options you’ll have for protection would be preventing anyone from modifying your spreadsheets. Google Sheets works a little differently. OneDrive and Google Drive are similar in that neither free service will truly be able to offer full password protection, unless you’ve already purchased OneDrive Premium or Microsoft Office. The process of password-protecting is almost the same, except you will only have access to this process by paying for OneDrive or Office 365 Premium. Setting passwords for other spreadsheet programs Microsoft OneDrive and Office 365įortunately, due Microsoft owning OneDrive and Office 365, the worksheet app is just Excel. You will then have to enter the password one more time to confirm it. Once you’ve entered your password of choice, click OK. Depending on the purpose of the Excel file, you can require a password to Open it, or to Modify it. Now another smaller box should open, presenting you with two choices of protection. Click on Tools and choose General Options… If you’re using the latest version of Excel, you will need to press the More Options link when you try to save the file.Ī new dialog box should appear, with a Tools drop-down menu next to the Save button along the bottom. Choose the Save As option under the File tab. Open up the Excel file you want to protect. What if I’m using older versions of Excel?įor older versions of Excel, the process is a bit more long-winded. This method only works with Windows 10 and beyond versions of Excel. It will help you create truly strong passwords - strong enough to guard your sensitive work or financial data. How do I set up a password on Excel files?īefore you start slapping passwords on all your important files, we recommend consulting this guide first.

This guide will help you set passwords to keep your files away from prying eyes or prevent anyone else from modifying them. Therefore, it’s a wise idea to protect these files the best way you can. Setting passwords for other spreadsheet programs.What if I’m using older versions of Excel?.How do I set up a password on Excel files?.

How to make an excel spreadsheet password protected