[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

210 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.

  152. I do agree with all the ideas you have presented in your post. They are very convincing and will definitely work. Still, the posts are very short for starters. Could you please extend them a little from next time? Thanks for the post.

  156. I was wondering if you ever considered changing the structure of your site? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two images. Maybe you could space it out better?

  160. Hello, Neat post. There’s a problem along with your web site in internet explorer, would check this… IE still is the marketplace leader and a large component to people will pass over your magnificent writing because of this problem.

  162. Awesome site you have here but I was wondering 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 online community where I can get feed-back from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Kudos!

  165. Hello There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and come back to read more of your useful information. Thanks for the post. I will certainly return.

  166. I have learn a few good stuff here. Definitely worth bookmarking for revisiting. I surprise how so much effort you place to create any such magnificent informative site.

  168. Thank you a lot for giving everyone an extraordinarily pleasant chance to check tips from here. It’s always very kind and packed with fun for me and my office acquaintances to visit your web site the equivalent of three times in one week to learn the newest secrets you have. And of course, I am also at all times pleased with all the exceptional things you serve. Certain two areas in this posting are unquestionably the most effective I have ever had.

  169. Simply wish to say your article is as amazing. The clarity on your submit is just excellent and that i can think you are a professional in this subject. Fine with your permission let me to clutch your feed to stay up to date with coming near near post. Thanks a million and please keep up the gratifying work.

  174. 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.

  181. Hello very nice web site!! Man .. Excellent .. Amazing .. I’ll bookmark your blog and take the feeds additionally…I’m happy to search out numerous helpful info right here within the submit, we want work out more techniques in this regard, thanks for sharing. . . . . .

  184. Hey there! Someone in my Facebook group shared this site with us so I came to look it over. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers! Fantastic blog and fantastic design.

  185. Awesome blog! Do you have any hints for aspiring writers? I’m hoping to start my own website 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 options out there that I’m totally confused .. Any tips? Kudos!

  186. Hi there! I could have sworn I’ve been to this website before but after checking through some of the post I realized it’s new to me. Anyhow, I’m definitely delighted I found it and I’ll be book-marking and checking back often!

  187. I have read some good stuff here. Certainly worth bookmarking for revisiting. I wonder how much effort you put to create such a great informative website.

  189. Its like you read my mind! You appear to know so much about this, like you wrote the book in it or something. I think that you could do with a few pics to drive the message home a bit, but other than that, this is wonderful blog. A great read. I’ll certainly be back.

  190. I as well as my friends have already been reading through the best things on your website while before long came up with a terrible suspicion I never thanked the site owner for those secrets. All of the guys came for that reason excited to read through all of them and already have actually been taking pleasure in them. Appreciate your actually being really accommodating and also for choosing these kinds of marvelous information millions of individuals are really wanting to be informed on. My very own honest regret for not saying thanks to earlier.

  192. The other day, while I was at work, my cousin stole my apple ipad and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My iPad is now broken and she has 83 views. I know this is entirely off topic but I had to share it with someone!

  197. Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently fast.

  199. I absolutely love your blog and find many of your post’s to be exactly what I’m looking for. can you offer guest writers to write content for you? I wouldn’t mind producing a post or elaborating on a lot of the subjects you write about here. Again, awesome site!

  200. Thanks for any other great article. Where else may anybody get that kind of information in such a perfect manner of writing? I’ve a presentation subsequent week, and I’m on the search for such info.

  208. This web site is really a stroll-via for all the data you needed about this and didn’t know who to ask. Glimpse here, and also you’ll undoubtedly uncover it.

  210. Excellent post. I was checking continuously this blog and I’m impressed! Very helpful info specifically the last part 🙂 I care for such info a lot. I was seeking this certain information for a very long time. Thank you and good luck.

Leave a Comment