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 .

select file in excel on windows

4.SelectInfofrom the sidebar .

5.Click onProtect Workbook .

6.SelectEncrypt with Password .

excel info menu in windows

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 .

protect workbook in excel in windows

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 .

encrypt excel file in windows

2.Find an Excel file from OneDrive and select it .

3.Select theSharebutton at the top .

4.From the Share link card , tap theEditbutton .

encrypt excel file with password in windows

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 .

enter password to access excel file

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 ?

share option in onedrive web

Microsoft OneNote Icons and Symbols Meaning – App/Desktop

50 Years of Microsoft: 11 Times Microsoft Fumbled and Missed…

How to Transfer Windows 11 to a New Drive/SSD (Step-by-Step)

Microsoft Office is Now Free on Desktop – But With…

How to Install Windows 11 on PC With Unsupported Hardware

Windows 10’s End is Near: What Are Your Options?

Windows 11 Camera Not Working? Here’s How to Fix It

Windows 11 “Resume” Feature: Seamlessly Switch Devices

Windows 11 Installation Has Failed? Easy Fixes to Try

Windows 11’s Multi-App Camera Support: How to Enable and Use…

edit excel link settings in onedrive

click link settings in onedrive web

set password to onedrive link