Locklizard
  • Products
    • DRM software
      • Safeguard PDF Security
      • Safeguard Enterprise
      • DRM Software Features
        • Restrict PDF use
        • Watermark PDF
        • Expire PDF
        • Revoke PDF
        • Disable Print
        • Track PDF
    • Secure PDF Viewers
      • Viewer Overview
      • Viewer Demo
      • Web Viewer
      • USB Viewer
    • Add-ons
      • All Add-ons
      • Web Publisher
      • Safeguard Portable USB
      • Ecommerce API
      • Command Line
      • Own Branding
      • Custom Email
    • Purchase & Pricing
    • Book a Demo
  • Solutions
    • Industry sectors
      • All Industries
      • Auctions
      • Engineering
      • Government
      • Healthcare
      • Libraries
      • Mergers & Acquisitions
      • Publishing Ebooks
      • Publishing Media
      • Publishing Standards
      • Membership Associations
      • Reports & Analysis
      • Tax Advisors
      • Training & Education
    • Vertical sectors
      • All Sectors
      • Board Documents
      • Internal Company Use
      • Large Publishers
      • Small Publishers
    • Business processes
      • Processes Overview
      • Secure Document Sharing
      • Sell Documents Securely
      • Document Retention
      • Prevent Document Leakage
      • Internal Document Control
      • Regulatory Compliance
      • Secure PDF Forms
      • Secure Data Rooms
      • Data Room Security
      • Application Integration
    • Business benefits
    • Regulatory compliance
      • Compliance Overview
      • NIST & DFAR Compliance
  • Downloads
    • Free 15 day trial
    • Viewers
      • Windows Viewer
      • Mac Viewer
      • iOS Viewer
      • Android Viewer
    • Writers
    • Manuals
  • Support
    • Support
    • FAQs
    • Guides
    • Videos
    • White papers
  • About Us
    • Contact us
    • Our customers
      • Customer Overiew
      • Case Studies
      • Testimonials
    • Our technology
      • What is DRM?
    • Blog
    • Why Locklizard?
      • Competitors
      • PDF DRM protection
      • Password protect PDF
      • Product Awards
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu

How to Password Protect an Excel File

in Blog, Document Security, DRM, PDF Security

How to Protect an Excel File to prevent copying & restrict editing

The security features Excel has to protect XLSX or XLS spreadsheets and why they are useless.  Learn how to secure your workbooks and worksheets without passwords, and how to encrypt them to restrict editing and printing, and prevent copying and sharing.

   Why protect Excel worksheets?


Microsoft Excel is a key application in the toolset of modern office workers, with 66% of professionals looking at a spreadsheet at least once per hour.  Employees use it to manage accounts, projects, budgets, tasks, and customer information, perform advanced statistical analyses, track inventory, and more.

Many of these tasks involve the processing of information that is not for public consumption.  Ask any executive if they want their draft financials or customer information on the open internet, and you’ll get a very clear answer. Unprotected Excel files are a liability in this regard.  Though you can likely trust the document’s creator and some team members, the same cannot always be said for those they share it with.

   Can Excel spreadsheets be protected?


Excel users have several forms of protection available to them.  The most widely used is password protection, in the form of open and editing passwords.  Spreadsheet creators can also add additional security measures such as watermarks and expiry date timers.  This blog will focus on opening and editing protection and preventing copying.

Excel password protection – is it secure?

Before we get into how to implement these mechanisms, a word of warning: they may not provide as much protection as you think.  Microsoft Excel’s password security can be bypassed or removed without much technical knowledge – we cover this in the section How to unlock or unprotect Excel workbooks or sheets.

If you require security suitable for the protection of worksheets with sensitive and confidential information, and need to restrict editing and prevent copying, sharing and printing, then skip to the section How to protect Excel spreadsheets without passwords.

   How to password protect an Excel file


We mentioned that Excel offers both open and editing passwords, but it is a little more complex than that.  As well as a password to open a document, Excel offers entire workbook protection, worksheet protection, and individual cells.

Regardless of the method used, you should not ignore the fundamentals of password security.  You must ensure they are long, complex, and unique to each document.  You’ll also need infrastructure in place in case users lose them and a way for users to store them securely.

   How to password protect Excel files from opening

Open passwords control who has access to an Excel file as a whole.  You can think of it as the first layer of password security.

Here’s how to password protect Excel files from opening:

  1. With your Excel document open, press File > Info, click on the Protect Workbook button, and choose “Encrypt with password”.
  2. Enter a strong password in the password field and press “OK”.
  3. Save your Excel file.

The workbook protection will ask for a password the next time a user tries to open it.

   How to make Excel read-only

There are many instances where you may trust a user enough to let them open an Excel file but not save a modified version.  Several built-in options exist to enforce this, including the “password to modify” built into Office documents.  This forces users to enter a password or open the document in read-only mode.

Here’s how to make and Excel document read-only:

  1. Press “File > Save as” and choose “Tools > General Options…” in the File Explorer menu.
  2. Enter a strong password in the “Password to modify” box and press “OK”.
  3. When a user opens a protected sheet, it will display in read-only mode unless they provide a valid password, preventing them from saving that specific document but not preventing the saving of a copy.

Note however that users can still export to PDF or other file formats, print, or save a copy, making this primarily useful only as a tool to prevent accidental editing.

   How to password protect an Excel worksheet against editing

Excel’s worksheet protection is the primary way to prevent accidental copy-pasting and editing.  There are various instances where Excel worksheet protection is useful, such as when you have a data or formula sheet you do not want users to modify.  Excel’s built-in functionality prevents the changing, moving, deleting, and copy-pasting of data from a given sheet.  It does not prevent printing, screenshots, or saving to other file formats.

Here’s how to password protect an Excel worksheet to restrict editing:

  1. Press “File > Info”, then “Protect Workbook > Protect Current Sheet”.  You can also use the review tab in the ribbon.
  2. Enter a strong worksheet password in the “Password to unprotect sheet” field.  Tick the actions you want to allow users to take.  Bear in mind that you will need to untick “Select cells” if you want to prevent users from copying and pasting.
  3. Press “OK” to apply the worksheet protection.

   How to use Excel to password protect cells

We can use the sheet protection outlined above to lock only specific cells, columns, or rows behind a password:

  1. Press Ctrl + A to select all cells in your sheet, then right-click and choose “Format Cells…”.
  2. In the “Protection” tab, untick “Locked” and press “OK”.
  3. Select only the cells you want to protect and do the opposite (tick “Locked”).
  4. In the Review tab of your ribbon, click “Protect Sheet” and enter a secure password.  Untick “Select locked cells”.

  How to password protect an Excel Workbook

Finally, you can password protect an Excel workbook’s structure to prevent users from adding, deleting, renaming, moving, copying, or inserting sheets.  The easiest way to do this is as follows:

  1. Open the Review tab of your ribbon and press “Protect Workbook”.
  2. Enter a secure password and press “OK”.  Save your document.

Users will not receive a pop-up telling them that the structure of your workbook is protected.  The option to modify sheets will just be greyed out, and they will not be able to make a new sheet or create hidden sheets.

   How to unlock or unprotect Excel workbooks or sheets


Now you have learned how to password protect Excel files, we’ll show you just how easy it is for users to remove this protection.  This is especially true for edit restrictions, which can be stripped by uploading to Google Drive or with some simple file renaming and editing.

   How to open a password protected Excel file

Protected Excel files can be opened by legitimate users who know the password, and illegitimate users can unprotect Excel sheets without the password using cracking tools.

How to unlock an Excel spreadsheet

It’s simple to unlock an Excel spreadsheet if you know the password.  Enter the password when prompted, and you can open and use the file for that session.

How to remove an open password from Excel

If you don’t want to enter the password each time you open the document, you’ll need to remove the open password entirely.

This is easier than you might think – after entering the password to gain access to the document, press “File > Info” Then “Protect Workbook > Encrypt with password”.

Delete the current password from the field so that it is blank, and save the changes.  Users will no longer be asked to enter a password when they open it.  As we’ll discuss later, this has security implications.

Unprotect Excel sheets without password using cracking tools

There are several applications to help remove the password protection from an Excel sheet or recover the open password to an Excel file.  It’s important to note that these typically do not recover the password instantly.  The amount of time depends on the complexity of the password, whether it uses any dictionary words, etc.

That said, tools such as Elcomsoft Advanced Office Password Recovery can try tens of thousands of passwords per second and uses data the user already knows about the password to speed along the process.  Many passwords can be cracked in minutes or days rather than weeks or months.

   How to edit a password protected Excel sheet


All forms of Excel editing protection, be that read-only mode, sheet protection, cell protection, or workbook protection can be removed both by those who have the password and those who don’t.  Indeed, because Excel’s editing protection is not backed by encryption it can be removed even easier than the open password mentioned above.

  How to edit a password protected Excel sheet legitimately

To edit a password protected Excel sheet legitimately, you’ll need to unprotect it using the password.

How to unprotect an Excel sheet

To unprotect a specific sheet, follow this process:

  1. In the “Review” tab of the ribbon, click “Unprotect Sheet”.
  2. Enter the password when prompted and press “OK”.

The protection will be permanently removed from the sheet.

  How to edit a protected Excel document without the password

How to change Excel from read only or remove editing restrictions

If you have applied editing protection to a specific sheet (i.e. you have made excel read only), you do not need the password to remove the protection.  This is hinted at by Microsoft in its documentation:

“Important: Worksheet level protection isn’t intended as a security feature. It simply prevents users from modifying locked cells within the worksheet. Protecting a worksheet is not the same as protecting an Excel file or a workbook with a password.”

There are various ways to create unprotected copies of Excel sheets, including printing to PDF and editing the document there.  However, we will show the methods that best maintain the document’s original formatting.

Since cell protection is just an extension of worksheet protection, the methods below apply to it, too.

Removing Excel edit protection with Google Sheets

Microsoft Excel sheet protection is only enforced by the application.  Other apps that can open Excel files can choose whether or not to honor this.  As a result, when an xlsx file is opened in Google Sheets, the protection is stripped and users can edit, copy-paste, save, etc.

Here’s how you can remove Excel protection using Google:

  1. Upload your edit protected sheet to a Google Drive account.
  2. Double-click the sheet to open it in Google Sheets and strip the protection.  Edit the sheet as much as you like.
  3. Press File > Download > Microsoft Excel (.xlsx).
Removing Excel edit protection with a zip program

If you do not have a Google account or do not want to content with the minor formatting changes Google Sheets can introduce, you can use a zip program to modify the document code instead.

Here’s how to remove Excel editing protection:

  1. Make a copy of your sheet and change its extension from .xlsx to .zip (note: you may have to select “View > Show > File name extensions” in File Explorer before you can see them.  Press “Yes” to confirm the change.
  2. Open the zip file and go to the “xl/worksheets” folder.  Open the .xml file corresponding to your sheet (in our case sheet1) in any text editor.
  3. Press Ctrl + F and search for “Protection”.  Delete the text that starts with <sheetProtection and ends with scenarios= "1"/>.  Save the file to your desktop.
  4. Drag the modified file from your desktop into the zip file and choose “Copy and Replace”.
  5. Change the .zip back to .xlsx and open the spreadsheet in Excel.  The protection should now be removed.

Alternatively, if you do not need to edit the original document you can export the sheet to another file type, such as PDF or .csv. (File > Export > CSV) and edit that.  This will generally have an effect on the look and formatting however.

   The reality of Excel password security


As you may have realized by now, Excel’s security is poorly thought out:

  1. Its open security relies on passwords, which can be cracked, phished, socially engineered, etc.
  2. Users with the password can also remove it and share the unprotected file with others.  They may accidentally share Excel sheets they previously removed the password from or fail to store the password in a secure location.
  3. For better security, you should use a new password for each Excel file, Excel; workbook, and Excel sheet – yet it would be a nightmare for admins to manage.  Even using a password manager requires caution since all of a user’s passwords are locked behind a single password, and you need a way to update every time a new password is issued.
  4. You cannot effectively protect an Excel sheet from editing.  Excel’s sheet editing restrictions are not designed as a security mechanism and are easily removed by editing a single XML file or uploading to Google Sheets.
  5. The modify password (set in File Explorer) just opens the document in read-only mode, which can be easily bypassed by saving a new copy of the file or exporting it to PDF.
  6. There is no way to prevent copying and sharing of confidential information.

We recommend not relying on Excel password protection or editing restrictions when sharing sensitive or confidential information.  The protection provided by Microsoft Excel should only be used to prevent accidental errors.

   How to protect Excel spreadsheets without passwords


It is possible to protect spreadsheets effectively and without passwords, but not in the Excel format.  The best security for confidential and sensitive spreadsheets or those containing important data, is found by saving them as PDFs and using DRM software such as Locklizard Safeguard.

Locked Excel documents are automatically protected against editing, copying, copy and paste, printing and sharing.  We do not use passwords.  Instead, we transmit decryption keys to an encrypted keystore on users’ devices they cannot access or share.  Meanwhile, Locklizard only ever decrypts documents in the computer’s memory, and our secure viewer application enforces anti-screenshot, editing, copying, and printing restrictions so they cannot be bypassed by scripts or plugins.

You can also insert an Excel watermark that is non-removable and dynamic, and enforce an expiry date or time limit.

   How to prevent copying, editing, printing and sharing

Here’s how you can use Locklizard to protect your spreadsheets in the PDF format.

  1. Open your Excel document and press “File > Export > Create XPS/PDF document” or Save As PDF.  Press “Options” in the File Explorer window to customize the output.
  2. Right-click on your PDF in Windows File Explorer and select the option “Make Secure PDF”.
  3. Choose any restrictions or security features you want to add to your spreadsheet by selecting them in the Writer application.  If you are wondering how to prevent an Excel document from being printed, for example, just untick “allow printing”.
  4. Press the “Publish” button at the bottom of the window to encrypt it.

    Upon publication, your document will be saved to its source folder in the .pdc file format, and you can safely share it, knowing that nobody can access it without a valid license.
  5. Add a user account and send them their license via the Safeguard admin portal.  See how to add a new user and grant them document access.

  The best way to protect your Excel spreadsheets


Excel’s default protection is not suitable for confidential and sensitive information.  Though password protection is a familiar security mechanism, it does not work well for preventing copying and sharing of documents.  Passwords are just too easy to remove and too challenging to manage, leading to spreadsheets being shared with unauthorized parties and edited at will.

Locklizard offers a streamlined and effective way to protect your Excel spreadsheets after they have been finalized.  Our DRM software prevents unauthorized editing, sharing, copying, printing, screenshots and enables expiry, non-removable watermarks, tracking, and more.  It provides modular control over which restrictions to enforce, who to enforce them on, and which users can access documents on which devices and locations.

Take a 15-day free trial today to see how Locklizard can protect your Excel files against unauthorized sharing and misuse.

   FAQs

How do I password protect an Excel spreadsheet?

There are several ways, including using Excel’s in-built security and third-party password encryption tools.  However, all password protection is inherently flawed because users can share the password with others.  Additionally, password-based editing controls aren’t enforced by encryption and are, therefore, easy to bypass.

How do I restrict access to an Excel file?

If you are serious about restricting access to Excel files, your best bet is to convert them to PDF and protect them using a DRM solution such as Locklizard.  This way, users can only open PDFs on devices you authorize and won’t be able to share them with others.

How can I tell if a XLSX workbook is protected?

If a workbook structure is protected in Excel, you can tell because the insert, delete, etc. options will be greyed out when you right-click on a sheet tab.  If access to the workbook is protected in Excel, then you will get a prompt to enter a password when you open it.  You can also check the Info tab in the file menu.

Locklizard-protected workbooks are clear because they will be in the .PDC format.

Can Locklizard protect Excel files in their native format?

No.  Locklizard only protects PDF files.  You can press “File > Save as Adobe PDF” in Excel to export your workbooks to the required format.

Are Excel plugins or scripts an effective form of protection?

No.  Plugins and scripts are too easy to break and do not offer any better protection than Excel’s built-in security.  They might work for the average person, but they are not suitable for use inside a business where sensitive and confidential information is shared.

Can I use Adobe Acrobat password security instead of Locklizard?

You can, but don’t expect to get better security than Excel offers.  Adobe passwords are even easier to remove because there are convenient online tools.

How can I make Excel read only and enforce this?

You can’t using Excel’s built-in security.  Excel’s read-only mode is not backed by encryption and is trivial for users to change Excel from read only back to editable form.

If you want to make Excel read only and enforce protection then you have to use Digital Rights Management controls.

How can I sell an excel spreadsheet and prevent copying?

You can convert it to PDF and use Safeguard DRM to prevent copying.  Safeguard will encrypt your Excel document and prevent copy and paste, copying to unprotected file formats, restrict editing and printing.  You can sell your Excel spreadsheet from your own website knowing that only authorized users can open it that they cannot share it with others since it is locked to an approved device.

Why doesn’t my version of Excel have the same security options?

If you are using an older version of Excel, it may not offer all forms of protection, and the names of others may be different.  For example, in Excel 2007, to password protect, you had to use the “Prepare” option in the file menu.  Excel 2011 has a “Permissions” icon in the ribbon for editing protection.  However, we always recommend using the latest version of Excel as this will contain the latest security patches.

Tags: excel password protect, excel prevent copying, excel prevent editing, excel protected view, excel restrict editing, excel security, how to lock cells in excel, how to protect cells in excel, how to secure excel file, how to unlock excel sheet, make excel read only, password protect excel, password protect excel file, prevent copy paste, protect excel, restricting access on excel, unprotect excel
Share this entry
  • Share on Facebook
  • Share on X
  • Share on WhatsApp
  • Share on Pinterest
  • Share on LinkedIn
  • Share on Tumblr
  • Share on Reddit
  • Share by Mail

Free Trial

“Fantastic product… outstanding support.”

“We would recommend Locklizard to others”

“The clear leader for PDF DRM protection”

“Our ebook sales have gone through the roof”

“Simple & secure – protects IPR from theft”

Trusted by:

Protect IPR

See why thousands of companies use Locklizard to safeguard their documents and increase revenue streams.

  • Our Customers
  • Customer Testimonials
  • Customer Case Studies
  • Locklizard vs Competitors

Latest Posts

  • Cloud Document Collaboration & Document SecurityFebruary 18, 2025 - 10:22 am
  • Stopping Screen Sharing & Recording of DocumentsJanuary 30, 2025 - 10:58 pm
  • ISO 9001 and Document SecurityJanuary 8, 2025 - 9:02 pm
  • How to expire links for file sharing and downloadsDecember 17, 2024 - 10:14 pm
  • Digital Libraries, Controlled Digital Lending & eBook DRMNovember 30, 2024 - 4:19 pm
PDF DRM Features
  • Protect PDF files
  • Stop PDF sharing
  • Stop PDF copying
  • Restrict PDF editing
  • Add PDF watermarks
  • Disable PDF printing
  • Stop screenshots
  • Expire PDF files
  • Revoke PDF files
  • Lock PDF to devices
  • Lock PDF to IP
  • Track PDF opens

How To Guides

How to stop sharing screen
How to expire download links
How to sell study notes
How to print to PDF
How to protect Autocad files
How to protect a document
How to unlock a protected PDF
How to expire Excel files
How to watermark in Excel
How to protect Excel files
Save a Google Doc as PDF
How to share a PDF online
How to insert PDF into Word
How to edit a protected PDF
How to convert ePub to PDF
How to prevent PDF download
How to share Google Docs
How to prevent PDF download
Enforce do not copy distribute
Share sell PDF in WordPress
How to remove a watermark
How to add security to PDF
Publish digital publications
How to share a PDF as a link
How to timestamp a PDF
Insert PDF into Google Doc
How to convert Word to PDF
How to convert PDF to Word
Share securely in SharePoint
How to encrypt email in Gmail
How to encrypt PDF files
How to recall unsend an email
How to watermark PowerPoint
How to lock a Word document
How to santize PDF files
How to lock a Google doc
Prevent PDF security removal
Protect Word without password
Add a dynamic watermark
Password protect Google Doc
Add a watermark in Word
Make a PDF non editable
How to create a stamped PDF
How to prevent ebook piracy
Password protect a Word doc
How to protect a PDF securely
How to revoke document access
Change PDF security settings
How to disable printing of PDFs
Sell online courses securely
How to add security to a PDF
Encrypt a PDF without Acrobat
Share documents securely
How to prevent PDF sharing
Protect confidential documents
How to publish ebooks securely
How to restrict PDF editing
How to password protect a PDF
How to protect ebooks
How to sell Reports securely
How to make a PDF read only
How to send a PDF securely
How to watermark a PDF
How to lock a PDF from editing
How to encrypt a PDF
How to make a PDF expire
How to password protect a PDF
How to protect online courses
How to email a PDF securely

Try Safeguard today

Start protecting your PDF files and documents from sharing & piracy

PRODUCTS

DRM Software
Safeguard
Safeguard Enterprise

Add-ons

  • eCommerce API
  • Command Line
  • USB Protect
  • Web Publisher
  • Own Branding
  • Custom Email

Secure PDF Viewers

  • Web Viewer
  • USB Viewer

SECURITY FEATURES

Stop copying, editing, saving
Disable PDF Prints
Block Screenshots
Disable Copy Paste
Dynamic Watermarks
Expiry & Self Destruct
Revoke Documents
Device Locking
Location Locking
Track PDF Use

PRICING

Purchase & Pricing

RESOURCES

FAQs
Locklizard Blog
Knowledgebase
Security Guides
White Papers
Viewer Demo
Videos

DOWNLOADS

Secure Viewers

  • Windows
  • Mac OS X
  • iOS
  • Android

Writers
Product Manuals
FREE Trial

DOCUMENT SECURITY

Share Documents Securely
Protect Online Courses
Stop Ebook Piracy
Document Encryption
Secure PDF Distribution
Protect Confidential Documents
Ebook DRM

Protect PDF Files

  • PDF Copy Protection
  • Lock PDF files
  • Encrypt PDF
  • Secure PDF
  • PDF DRM

INDUSTRY SECTORS

Training & Elearning
Publishing Ebooks
Publishing Standards
Online Libraries
Membership Associations
Engineering
Government
Healthcare
Mergers & Acquisitions
Secure Reports From Theft

  ABOUT US

About Us

Our DRM Technology

  • What is DRM?

Customers

  • Case Studies
  • Testimonials

Locklizard vs Competitors

  • Secure Data Rooms

Company Brochure

  CONTACT

sales@locklizard.com
support@locklizard.com

Business Hours:
US: 8AM to 17.00PM EST
UK: 9AM to 17.30PM GMT

© Copyright 2004-2025 Locklizard Limited. All rights reserved.Privacy Policy|GDPR Policy|Cookie Policy|SITE MAP

Link to: Are Virtual Data Rooms (VDRs) Secure? Link to: Are Virtual Data Rooms (VDRs) Secure? Are Virtual Data Rooms (VDRs) Secure?Link to: How to insert a Watermark in Excel and prevent removal Link to: How to insert a Watermark in Excel and prevent removal How to insert a Watermark in Excel and prevent removal
Scroll to top Scroll to top Scroll to top