[How To] Password Protecting Excel Workbook

by

Microsoft Excel logo

Welcome back readers, it’s been a while since we posted any tutorial. It’s been a hectic year for me and I’m glad that finally I could find some time to write a yet another tutorial.

Microsoft Office suite does provide all of us with the most brilliant productivity tools that would foster our business/professional growth through their vast line up of dedicated software.

And the Microsoft Excel is a vital part of the office suit which often finds its regular usage among business organizations, educational institutions, government offices, and all other locations where the emphasis will be on storing some important data.

Having known the vital role that the Microsoft Excel plays in the business process, it would really be a big blunder on part of the users who use Excel if they don’t learn the security aspects related to the software. To make sure the data stored in a Excel sheet is opened or used by a competent authorised party, the creator of the Microsoft Excel sheet should take care of certain security measures which are incorporated within the Excel suite.

Any Excel worksheet can be secured in two ways:

1) Protecting the entire worksheet (asks password when the file is opened)

2) Protecting the data inside the worksheet (file can be opened but password will be required to view the worksheet elements)

The second type of the protection is perhaps the most widely known as the option for the same is available within the workbook menu items.

In this tutorial we are concerned with protecting the entire workbook rather than the individual elements inside the worksheet. The reason why anyone would need this kind of protection is simple: they don’t want others to see the worksheets in the first place.

Protecting the Excel Workbook:

Step 1: Open the the Excel workbook for which you want to add password protection.

Microsoft Excel Menu Info options

2. Click on the “File” menu item. Locate “Info’ heading under the “File” menu and click on it.

3. Under the “Info” sections, you will have three options: Permissions, Prepare for Sharing and Versions. Click on the item “Permissions” (on the “Protect Workbook” dropdown item).

4. You will be presented with various options. You need to click on the second item on the list i.e, “Encrypt with password”.

Encrypt Excel workbook with password

5. It will then ask you to enter a password for encrypting the workbook. You may need to reenter the password to affect the change.

Encrypt Excel document with password

6. Save the workbook and try to open again. It will now show this kind of message and asks you to enter the password.

Excel Workbook password open

The same result can be achieved by a slightly different step. Click on the “Save As” button under the “File Menu”. It will now take you to the choosing the location window. Click on “Tools” dropdown menu on the left of the “Save” button.

Under the “Tools” dropdown menu, choose “General Options”.

general options tools save as in Excel

It will now ask you to enter a password that needs to be entered to open (or ‘modify’) the workbook.

General options open Workbook in Excel

Once entered and saved, the workbook becomes password protected and the same needs to be entered on each instance when trying to open the workbook.

Note: This tutorial is based on Microsoft Excel 2010 earlier version and may not be suitable for earlier versions.

Related Posts with Thumbnails

150 thoughts on “[How To] Password Protecting Excel Workbook”

  1. Excel workbooks are really useful for businesses for their financial accounts and other data that you can think of. With the integration of these files to different programming languages it is pretty easy to create excel workbooks optimized for business and you can easily encrypt them using this tutorial, the process of which can also be coded.

  2. Password for Excel worksheet is very useful, i am working daily on many of excel sheets which are very important, now this idea is very beneficial for me to make them locked. Thanks for making me know about this.    

  63. Im not positive where you are getting your info, but good topic. I needs to spend some time studying much more or working out more. Thank you for wonderful info I used to be searching for this information for my mission.

  64. Hi , I do believe this is an excellent blog. I stumbled upon it on Yahoo , i will come back once again. Money and freedom is the best way to change, may you be rich and help other people.

  65. I’m curious to find out what blog platform you are utilizing? I’m experiencing some minor security issues with my latest website and I would like to find something more safe. Do you have any solutions?

  66. Howdy! I know this is somewhat off topic but I was wondering which blog platform are you using for this website? I’m getting fed up of WordPress because I’ve had problems with hackers and I’m looking at alternatives for another platform. I would be awesome if you could point me in the direction of a good platform.

  68. Hello there, just changed into alert to your blog through Google, and located that it’s really informative. I’m gonna be careful for brussels. I’ll appreciate should you proceed this in future. A lot of folks might be benefited out of your writing. Cheers!

  71. What’s Happening i am new to this, I stumbled upon this I have found It positively helpful and it has helped me out loads. I hope to contribute & aid other users like its helped me. Great job.

  72. Unquestionably believe that which you said. Your favorite justification seemed to be on the net the simplest thing to be aware of. I say to you, I certainly get annoyed while people think about worries that they just don’t know about. You managed to hit the nail upon the top and also defined out the whole thing without having side-effects , people could take a signal. Will probably be back to get more. Thanks

  77. Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.

  79. I’ve been browsing on-line more than three hours these days, yet I by no means discovered any interesting article like yours. It is lovely worth sufficient for me. In my view, if all webmasters and bloggers made excellent content material as you probably did, the net will probably be much more useful than ever before.

  81. I’m impressed, I must say. Actually rarely do I encounter a blog that’s each educative and entertaining, and let me tell you, you’ve gotten hit the nail on the head. Your thought is excellent; the issue is one thing that not sufficient persons are speaking intelligently about. I’m very comfortable that I stumbled throughout this in my seek for one thing referring to this.

  85. I really like your writing style, fantastic info, appreciate it for posting :D. “He wrapped himself in quotations- as a beggar would enfold himself in the purple of Emperors.” by Rudyard Kipling.

  89. NuStarGame refers to a digital entertainment platform designed to provide users with an organized and accessible online experience. The platform focuses on clean interface design, smooth navigation, and compatibility across multiple devices, making it suitable for users looking for a structured digital environment.

  91. I haven’t checked in here for some time because I thought it was getting boring, but the last few posts are great quality so I guess I’ll add you back to my daily bloglist. You deserve it my friend 🙂

  97. I was just looking for this info for a while. After six hours of continuous Googleing, at last I got it in your site. I wonder what’s the lack of Google strategy that do not rank this type of informative sites in top of the list. Normally the top websites are full of garbage.

  99. Wonderful beat ! I would like to apprentice while you amend your website, how can i subscribe for a blog site? The account helped me a acceptable deal. I had been tiny bit acquainted of this your broadcast offered bright clear concept

  101. Hi, Neat post. There is an issue along with your site in internet explorer, may test thisK IE still is the market leader and a large element of other folks will miss your wonderful writing because of this problem.

  103. Pretty nice post. I just stumbled upon your weblog and wished to say that I have truly enjoyed browsing your blog posts. After all I’ll be subscribing to your rss feed and I hope you write again soon!

  104. Very good blog! Do you have any suggestions for aspiring writers? I’m hoping to start my own site soon but I’m a little lost on everything. Would you suggest starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m completely overwhelmed .. Any suggestions? Thank you!

  105. Fantastic blog you have here but I was curious about if you knew of any message boards that cover the same topics discussed in this article? I’d really love to be a part of community where I can get suggestions from other experienced people that share the same interest. If you have any suggestions, please let me know. Appreciate it!

  106. I have not checked in here for a while as I thought it was getting boring, but the last few posts are great quality so I guess I¦ll add you back to my daily bloglist. You deserve it my friend 🙂

  108. I haven?¦t checked in here for a while since I thought it was getting boring, but the last few posts are good quality so I guess I will add you back to my daily bloglist. You deserve it my friend 🙂

  109. Nice post. I learn something more difficult on totally different blogs everyday. It will all the time be stimulating to learn content material from different writers and observe a bit of one thing from their store. I’d want to use some with the content material on my blog whether you don’t mind. Natually I’ll provide you with a hyperlink in your internet blog. Thanks for sharing.

  110. This web site is really a walk-through for all of the info you wanted about this and didn’t know who to ask. Glimpse here, and you’ll definitely discover it.

  111. I haven’t checked in here for a while because I thought it was getting boring, but the last few posts are great quality so I guess I will add you back to my daily bloglist. You deserve it my friend 🙂

  116. Great – I should definitely pronounce, impressed with your website. I had no trouble navigating through all tabs as well as related information ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or something, web site theme . a tones way for your customer to communicate. Nice task..

  120. I used to be recommended this blog by means of my cousin. I am now not positive whether or not this publish is written through him as nobody else understand such precise approximately my problem. You are wonderful! Thank you!

  121. Hmm is anyone else having problems with the pictures on this blog loading? I’m trying to figure out if its a problem on my end or if it’s the blog. Any feed-back would be greatly appreciated.

  122. Attractive element of content. I simply stumbled upon your blog and in accession capital to claim that I get actually enjoyed account your blog posts. Anyway I will be subscribing on your augment or even I achievement you get admission to constantly rapidly.

  123. I do believe all the ideas you’ve offered for your post. They’re very convincing and can certainly work. Still, the posts are very quick for novices. Could you please extend them a little from subsequent time? Thank you for the post.

  125. Can I simply say what a aid to seek out somebody who really knows what theyre speaking about on the internet. You positively know the best way to carry a difficulty to mild and make it important. Extra folks have to read this and understand this facet of the story. I cant imagine youre no more in style because you undoubtedly have the gift.

  128. I like what you guys are up also. Such clever work and reporting! Carry on the excellent works guys I have incorporated you guys to my blogroll. I think it will improve the value of my website :).

  130. Thanks a bunch for sharing this with all of us you really recognize what you are talking approximately! Bookmarked. Kindly additionally consult with my site =). We will have a hyperlink alternate contract among us!

  133. Aw, this was a very nice post. In concept I wish to put in writing like this moreover – taking time and precise effort to make an excellent article… but what can I say… I procrastinate alot and not at all seem to get one thing done.

  134. Hey! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My weblog looks weird when viewing from my iphone. I’m trying to find a theme or plugin that might be able to fix this issue. If you have any recommendations, please share. With thanks!

  137. Thank you for another magnificent article. Where else could anyone get that kind of information in such an ideal way of writing? I’ve a presentation next week, and I am on the look for such info.

  138. I have been surfing online more than 3 hours today, but I never discovered any fascinating article like yours. It is beautiful price enough for me. In my view, if all website owners and bloggers made good content material as you probably did, the internet will be much more helpful than ever before.

  139. Thanks for your whole labor on this web page. My daughter delights in making time for research and it’s really obvious why. Almost all know all relating to the powerful mode you create efficient information by means of your web site and recommend response from some other people about this area of interest and my daughter has always been studying a lot of things. Have fun with the rest of the year. You have been conducting a fabulous job.

  146. Undeniably believe that which you stated. Your favorite reason appeared to be on the net the easiest thing to be aware of. I say to you, I definitely get annoyed while people think about worries that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks

  147. Normally I do not read post on blogs, but I wish to say that this write-up very forced me to try and do so! Your writing style has been amazed me. Thanks, quite nice post.

  149. I simply needed to thank you so much yet again. I’m not certain the things I might have achieved without the type of creative ideas revealed by you on that theme. Certainly was the depressing matter in my circumstances, nevertheless observing a skilled tactic you solved the issue forced me to cry over joy. I am just happy for the support and as well , wish you are aware of a powerful job that you’re accomplishing instructing the mediocre ones via your webblog. Probably you haven’t got to know any of us.

Leave a Comment