Find out how to lock or unlock a spreadsheet

Microsoft Excel is a most well-liked software program for professionals to crunch necessary numbers. If you take care of confidential spreadsheets like firm quarterly stories, gross sales knowledge, advertising budgets, expense stories, journey planners, warehouse inventories, and extra, lock them with a password to keep away from unauthorized entry. Whether or not you employ the Excel apps on Home windows and Mac or Excel internet on a Chromebook, verify the highest methods to password-protect an Excel spreadsheet.


What are Excel macros?

Be taught what Excel macros are, how one can create them, and the place you should utilize macros to automate duties, save time, and increase productiveness

Lock and shield an Excel sheet on Home windows

You’ll be able to lock an Excel sheet from the Information menu. It is probably the most simple strategy to enter a password right into a workbook. Observe these steps to make modifications:

  1. Open Microsoft Excel and choose the sheet you wish to lock.
  2. Make the required modifications.
  3. When you’re able to share, click on File on the prime.
    Excel file menu

  4. Choose Information from the sidebar.
  5. Choose Defend Workbook.
  6. Click on Encrypt with Password.
    Protect current Excel sheet

  7. Enter the password and ensure it from the next menu. Passwords are case-sensitive.
    Encrypt excel file

  8. Click on OK. You may see A password is required to open this workbook message. Your Excel file is password-protected and secure from prying eyes.
    Excel file is protected

Any more, once you open an Excel file, it asks for a password to entry content material. Enter your password and click on OK to unlock it.

Defend the workbook construction

You can even shield the workbook construction to stop undesirable modifications to the construction of the workbook (comparable to including or eradicating sheets).

  1. Go to Excel File > Information > Defend Workbook > Defend Workbook Construction.
    Protect current Excel sheet

  2. Enter the password.
    Protect Excel structure

  3. Renter the password and click on OK.
    Reneter excel structure password

Defend the present sheet

There may be one other safety choice referred to as Defend Present Sheet. It gives extra management over the modifications individuals could make to the present sheet.

  1. Go to Excel File > Information > Defend Workbook > Defend Present Sheet.
    Protect current Excel sheet

  2. Enter the password to guard the sheet.
  3. Choose the checkmark beside the required choices that different customers can entry and click on OK.
    Excel sheet protection options

  4. Enter your password once more and click on OK to guard the sheet.
    Confirm password for excel sheet protection

If you add a password, reserve it to a password supervisor. Should you neglect it, Microsoft cannot retrieve it. In addition to, passwords are usually not restricted. They’ll encompass numbers and particular characters and will be any size.

Watch out when sharing password-protected Excel sheets with others. You’ll be able to’t rule out the opportunity of your password falling into the unsuitable fingers. Additionally, locking an Excel file with a password would not shield it from malicious content material.

Lock an Excel spreadsheet on Mac

Microsoft gives an Excel app on Mac. Should you use Excel on Mac, undergo the tips under to lock an Excel sheet.

  1. Launch Excel on Mac and choose the spreadsheet you wish to shield.
  2. Click on File on the prime and choose Passwords.
    Password in Excel for Mac

  3. Enter the password to open and modify an Excel sheet. Each will be completely different passwords. Verify your password from the next menu.
    Enter password to lock Excel on Mac

  4. Click on OK and you’re good to go.
    confirm password for Excel on Mac

Any more, once you open a locked Excel sheet, it asks for a password. The software program once more asks for a password if you wish to make modifications.

The Defend Sheet and Defend Workbook choices can be found beneath the Assessment tab. Should you desire them, choose a related choice to guard your Excel file content material and construction.

Should you use Microsoft’s OneDrive cloud platform to save lots of and share Excel recordsdata, you may password-protect and set an expiry date for a shared hyperlink. For instance, you may set an expiry of every week, and OneDrive makes the shared hyperlink inaccessible after the set date.

  1. Open an Excel file and reserve it to a OneDrive folder.
  2. Click on Share on the prime and choose Hyperlink to this Sheet.
  3. Add your sheet to OneDrive.
    Link to Excel sheet

  4. Choose Anybody with the hyperlink can edit.
    Link editing options for Excel

  5. Choose the related permission beneath Extra settings.
  6. Choose an expiry date.
    Enter Excel link password and expiry link

  7. Set a password and click on Apply.
    Excel link settings

  8. Copy and share your hyperlink.

The recipient should enter a password to entry your Excel sheet.

Unlock and unprotect an Excel spreadsheet

At any level, you may unlock and unprotect an Excel spreadsheet from a posh password. Here is how:

  1. Go to the Defend Workbook menu beneath Excel Information (check with the steps above).
  2. Choose Encrypt with Password.
    remove password from Excel file

  3. Take away your current password and click on OK.
    remove password from excel

From right here on, Excel would not ask for a password to open the file. To unprotect a workbook, go to Assessment > Defend Workbook and enter the password. Click on OK.

Unprotect workbook on Excel

Equally, you may unprotect a sheet from the Assessment > Unprotect Sheet menu.

Unprotect sheet on Excel

Safeguard your necessary Excel spreadsheets

Unauthorized entry to your personal Excel recordsdata can put you in a jeopardized place. Excel has a number of tips to maintain your important knowledge secure. Creating an Excel sheet from scratch is a time-consuming course of. Should you do not wish to take care of repetitive duties, create a macro to automate complicated steps in a sheet. You can even discover the highest Excel templates to edit and full your workbook shortly.

Leave a Reply

Your email address will not be published. Required fields are marked *