Ask Dave Taylor
  • Facebook
  • Instagram
  • Linkedin
  • Pinterest
  • Twitter
  • YouTube
  • Home
  • Videos
  • Most Popular
  • Top Categories
  • Books
  • About Dave
  • Ask Me
  • > Donate <
  • Home
  • Mac & MacOS Help
  • How Do I Password Protect my Excel Spreadsheets?

How Do I Password Protect my Excel Spreadsheets?

January 12, 2021 / Dave Taylor / Mac & MacOS Help, Windows 10 Help / No Comments

My banker wants to go through my company spreadsheets and I don’t want to just email them as attachments. Is there a way to password protect XLS files before sending or sharing them? I use Microsoft Excel on my Mac if that matters…

While the odds of someone intercepting an email and sharing or reading your confidential spreadsheet is quite low, you’re right to be concerned because it’s not zero. Worse, that file will also live in your sent email archive, the recipient’s received email archive and possibly cloud backup copies of both too. That’s a lot of places for something you undoubtedly do not want to ever bee seen by your competitors or new companies considering entry into your market segment! Fortunately all modern office software, from Apple Pages to Microsoft Excel supports password protected files. This means that even if your recipient is using Excel on a Windows PC or Numbers on their own Mac, the password protection remains with the XLS file.

How secure the password protection is can be debated as there are “unlock Microsoft office” hacker programs out there, but I don’t have any experience using them and my guess would be if you use a sufficiently long and complicated password (e.g., “Fd#4dgjrJD83.” rather than “mybiz“) you’ll be protected from overzealous hackers or industrial espionage too. If it’s that much of a concern in your business segment, I’d probably overnight a flash drive or similar instead. But for 99% of us, that’s massive overkill.

So how do you password protect a spreadsheet document in Microsoft Excel on a Mac? Let’s have a look…

HOW TO PASSWORD PROTECT AN EXCEL SPREADSHEET

Turns out that the user interface is remarkably similar between the Office programs on a Mac and PC, so while I’ll demonstrate the steps on the Mac version, readers with the PC version of Office – or Office 365 – should be able to readily follow along. Here’s a spreadsheet to get us started:

microsoft excel spreadsheet

Look a bit more closely at the window frame and buttons along the top, because the one we want is kind of an old-school icon and easily missed:

microsoft excel for mac - save as button icon

The tiny floppy disk icon with the pencil is the “Save As…” feature. This is also accessible through File > Save As… but the icon’s more old school and therefore inherently more fun, right? 🙂

A click on it and you’ll see the usual Save As window:

microsoft excel for mac - save as

You can rename it, switch to an online location like OneDrive or DropBox, and even change the file format if Excel 97-2004 isn’t what you want. But the important button here is “Options…” which offers up those password features:

microsoft excel for mac - password open modify read only

Yes, plural, passwords. There are two levels of password protection with an Excel XLS document: A password to open the spreadsheet and a second password needed to modify it. You can also just mark it as “read only” if you want to prevent people from modifying any of the values before forwarding it along to others, if that’s a possibility. If you don’t specify one of these passwords, it won’t be in effect, so you can quite reasonably have an open password but not a modify one, for example. Specify just that and click “OK“.

Excel will then warn you that there is a bit of risk involved in this path:

microsoft excel for mac - confirm password to open

Since you do want to proceed, just carefully type in the exact same password again and click “OK” one more time.

Done. Now you have a password protected spreadsheet on your Mac, as the icon highlights:

microsoft excel for mac - mac icon password protected xls

So what about opening it to read and modify?

OPENING UP A PASSWORD PROTECTED EXCEL XLS FILE

Turns out that while there are a lot of ways to view or preview a document on a Mac, it all works exactly as you would hope in terms of privacy and data protection. For example, try to preview it by clicking once on the icon and pressing the space bar and you’ll get this prompt:

microsoft excel for mac - preview password protected

Try to open it up in Excel on your Mac and you’ll get a prompt:

microsoft excel for mac - prompt for open password

Heck, try to be sneaky and open it up in Apple Numbers, another spreadsheet program, and you’ll again be prompted for that password:

apple numbers - prompt for open password xls

More importantly, if you copy the file over to a Windows PC and try to open it in Microsoft Excel for Windows, it will indeed prompt for that password:

excel windows pc - prompt for password open xls

Oh, and since we have an older XLS format file instead of the more modern Excel XLSX, Excel is a bit cautious about it once you do open up the spreadsheet:

microsoft excel for windows pc - warning about malware

So that’s it. How you can protect your spreadsheet on the Mac (or PC) so that it’s much more secure across the various platforms and as it travels through the Internet. Not a bad idea to keep things password protected just on your computer too, in case you ever lost your computer or had it stolen!

Pro Tip: I’ve been writing about Windows and Mac for years. Please check out my extensive Windows help library with lots of cool tutorials and how-to articles while you’re visiting. Thanks!

Let’s Stay In Touch!

Never miss a single article, review or tutorial here on AskDaveTaylor, sign up for my fun weekly newsletter!
Name: 
Your email address:*
Please enter all required fields
Correct invalid entries
No spam, ever. Promise. Powered by FeedBlitz
Please choose a color:
Starbucks coffee cup I do have a lot to say, and questions of my own for that matter, but first I'd like to say thank you, Dave, for all your helpful information by buying you a cup of coffee!
excel open password, excel password, password protect, password protect spreadsheet, password protect xls

Leave a Reply Cancel reply

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

Search

Recent Posts

  • How to Customize Quick Access Toolbar in Microsoft Word?
  • Can I Have Microsoft Edge Suggest Strong Passwords?
  • How Can I Password Protect Tax Forms Sent Via Email?
  • Easy Way to Add Emoji to Tweets from a Web Browser?
  • How Do You Post Multiple Photos in Instagram?

On Our YouTube Channel

Andobil Cup Holder Phone Mount -- DEMO & REVIEW

DIGDIY BUDGET ANC TWS Earbuds [D10WH] -- REVIEW

Categories

  • AdSense, AdWords and PPC Help (106)
  • Amazon Echo & Kindle Help (79)
  • Amazon, eBay and Online Shopping Help (157)
  • Android Help (158)
  • Apple Watch Help (49)
  • Articles, Tutorials and Reviews (326)
  • Business Advice (191)
  • Computer and Internet Basics (714)
  • d) None of the Above (160)
  • Facebook Help (364)
  • Google & Gmail Help (154)
  • HTML and Web Design (243)
  • Instagram Help (43)
  • iPad Help (136)
  • iPhone Help (570)
  • LinkedIn Help (79)
  • Linux Help (147)
  • Linux Shell Script Programming (86)
  • Mac & MacOS Help (831)
  • Most Popular (10)
  • MP3 Player Help (181)
  • Outlook & Office 365 Help (9)
  • PayPal Help (68)
  • Pinterest Help (53)
  • Reddit Help (11)
  • SEO & Marketing (80)
  • Spam, Scams & Security (82)
  • Trade Show Updates (23)
  • Twitter Help (212)
  • Video Game Tips (66)
  • Web Site Traffic Tips (62)
  • Windows 10 Help (825)
  • Wordpress Help (201)
  • Writing and Publishing (72)
  • YouTube Help (43)
  • YouTube Video Reviews (159)
  • Zoom, Skype & Video Chat Help (40)

Archives

Social Connections:

Ask Dave Taylor


Follow Me on Pinterest
Follow me on Twitter
Follow me on LinkedIn
Follow me on Instagram


AskDaveTaylor on Facebook



microsoft insider mvp


This web site is for the purpose of disseminating information for educational purposes, free of charge, for the benefit of all visitors. We take great care to provide quality information. However, we do not guarantee, and accept no legal liability whatsoever arising from or connected to, the accuracy, reliability, currency or completeness of any material contained on this site or on any linked site. Further, please note that by submitting a question or comment you're agreeing to our terms of service, which are: you relinquish any subsequent rights of ownership to your material by submitting it on this site. Our lawyer says "Thanks for your cooperation."
© 2020 by Dave Taylor. "Ask Dave Taylor®" is a registered trademark of Intuitive Systems, LLC.
Privacy Policy - Terms and Conditions - Accessibility Policy