Are you plan to partake the latest sales results or company quarter data using an Excel file ? Of naturally , you wo n’t want any unauthorized access to such sensitive datum besides the top direction . The best means to protect such Indian file is via watchword protection . you’re able to easily summate a password to an Excel file on Windows and OneDrive . Here ’s how .
Password Protect an Excel File on Windows
There are two ways to password protect an Excel file on Windows . you may either use the default Excel screen background app or opt for OneDrive to add password protection before sharing a liaison to the file . We will discuss both method acting , but first , we will embark on with the desktop .
Use Microsoft Excel App
1.OpenMicrosoft Excelsoftware on Windows .
2.start the single file you desire to password - protect .
3.Make necessary modification and click onFileat the top .
4.SelectInfofrom the sidebar .
5.Click onProtect Workbook .
6.SelectEncrypt with Password .
add together a countersign to cipher the content of this single file and hitOKat the bottom . Do mention that if you miss or blank out the watchword , it can not be reset or reclaim .
Reenter the password again and snap OK . From now on , whenever you or anyone tries to reach the Excel file , the app will present you with a dialogue box to enter the watchword . Type the correct countersign and hitOKto admission the data file data .
Office 2016 - 2019 practice secure AES-256 encryption that is unbreakable within a sensible time .
We would advise you to keep a list of countersign and their corresponding written document names in a safe topographic point . you could opt for a dedicated password director such as1Password , Dashlane , or LastPassto storage sore data securely .
Use OneDrive Web to Password Protect an Excel File
Since you are using Excel on Windows 10 or Windows 11 , chance are , you are already pay for one of the Microsoft 365 program .
Using that , you may even add an expiry escort after which , the file will no longer be available .
1.Visit OneDrive on the web and sign in using your Microsoft report certificate .
2.Find an Excel file from OneDrive and select it .
3.Select theSharebutton at the top .
4.From the Share link card , tap theEditbutton .
5.SelectLink configurations .
6.From the following bill of fare , you have an option toSet a password .
7.Add password and click onApplybutton at the bottom . From the same carte du jour , you may position the expiration particular date as well .
For example , you add an expiry date for a workweek and after the escort / time has come to run , the OneDrive nexus will become inactive .
Anyone with memory access to the OneDrive link will need a watchword to enter the data . Using the same trick , you could append password protection to any file on OneDrive that you plan to deal .
Wrapping Up: Password Protect an Excel File
Even though the spreadsheet market is filled with the like of Google Sheets , Apple Numbers , and newbies like Airtable and Coda , Microsoft Excel remains unrivalled , peculiarly in the business and initiative sphere .
In some sheath , it makes absolute sense to protect confidential Excel filing cabinet . Go onward , habituate the trick above and apply brakes to unauthorised access to Excel files with a password .
Did you recognise you cancreate an app from an excel sheetthat users can download and put in on their smartphones ?