[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

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

  211. Just desire to say your article is as amazing. The clarity in your post is just excellent and i could assume you are an expert on this subject. Well with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please keep up the enjoyable work.

  212. I do agree with all of the ideas you’ve presented in your post. They’re very convincing and will definitely work. Still, the posts are too short for novices. Could you please extend them a bit from next time? Thanks for the post.

  215. After study a few of the blog posts on your website now, and I truly like your way of blogging. I bookmarked it to my bookmark website list and will be checking back soon. Pls check out my web site as well and let me know what you think.

  217. I know this if off topic but I’m looking into starting my own weblog and was wondering what all is needed to get setup? I’m assuming having a blog like yours would cost a pretty penny? I’m not very web savvy so I’m not 100 certain. Any tips or advice would be greatly appreciated. Cheers

  218. There are certainly a number of details like that to take into consideration. That could be a great level to deliver up. I supply the ideas above as common inspiration however clearly there are questions just like the one you carry up where the most important thing will be working in honest good faith. I don?t know if greatest practices have emerged around things like that, however I’m certain that your job is clearly identified as a fair game. Each boys and girls really feel the impression of only a second’s pleasure, for the rest of their lives.

  219. I’m really enjoying the design and layout of your website. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Excellent work!

  221. I have been exploring for a little bit for any high-quality articles or blog posts on this kind of house . Exploring in Yahoo I finally stumbled upon this website. Studying this info So i am glad to convey that I’ve an incredibly excellent uncanny feeling I discovered just what I needed. I most for sure will make sure to don’t disregard this site and give it a glance on a constant basis.

  222. You really make it seem so easy with your presentation but I find this matter to be actually something which I think I would never understand. It seems too complicated and extremely broad for me. I’m looking forward for your next post, I will try to get the hang of it!

  223. Thank you for the auspicious writeup. It in fact was a amusement account it. Look advanced to far added agreeable from you! However, how can we communicate?

  224. Just want to say your article is as astounding. The clarity in your put up is just cool and i could assume you’re a professional on this subject. Well along with your permission allow me to snatch your feed to keep up to date with impending post. Thank you one million and please continue the gratifying work.

  226. Thank you a lot for providing individuals with such a memorable opportunity to read critical reviews from this website. It is often very good and also packed with a great time for me and my office friends to search your blog at least thrice in 7 days to learn the fresh stuff you have got. And lastly, I’m just certainly fulfilled concerning the attractive principles you give. Some 1 ideas in this article are undeniably the finest I have ever had.

  227. Thanks , I’ve just been looking for info approximately this topic for a while and yours is the best I’ve found out till now. But, what in regards to the bottom line? Are you positive concerning the source?

  228. You can definitely see your skills in the work you write. The world hopes for even more passionate writers like you who are not afraid to say how they believe. Always follow your heart.

  229. Great paintings! This is the type of information that are supposed to be shared around the internet. Shame on the seek engines for no longer positioning this submit upper! Come on over and seek advice from my web site . Thanks =)

  232. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something informative to read?

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

  236. Hello! I could have sworn I’ve been to this blog before but after browsing through some of the post I realized it’s new to me. Anyways, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!

  237. Helpful information. Lucky me I discovered your site unintentionally, and I am shocked why this accident didn’t happened in advance! I bookmarked it.

  239. naturally like your web site however you have to test the spelling on quite a few of your posts. A number of them are rife with spelling issues and I find it very troublesome to tell the reality on the other hand I’ll surely come back again.

  243. Wow that was odd. I just wrote an really long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again. Anyways, just wanted to say excellent blog!

  246. Having read this I thought it was very informative. I appreciate you taking the time and effort to put this article together. I once again find myself spending way to much time both reading and commenting. But so what, it was still worth it!

  247. Good day! I just would like to give an enormous thumbs up for the good info you may have here on this post. I will likely be coming again to your blog for more soon.

  248. I as well as my friends came analyzing the excellent secrets located on your site while then developed a horrible feeling I never thanked you for those strategies. These boys ended up for that reason happy to see them and have now without a doubt been making the most of those things. Thanks for truly being well thoughtful as well as for making a choice on these kinds of smart subject matter millions of individuals are really desirous to know about. My personal sincere apologies for not saying thanks to earlier.

  252. I like what you guys are up too. Such smart work and reporting! Carry on the excellent works guys I’ve incorporated you guys to my blogroll. I think it will improve the value of my website 🙂

  253. We absolutely love your blog and find most of your post’s to be exactly I’m looking for. Would you offer guest writers to write content available for you? I wouldn’t mind writing a post or elaborating on a few of the subjects you write regarding here. Again, awesome blog!

  254. Thanks for sharing superb informations. Your website is so cool. I’m impressed by the details that you have on this web site. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for extra articles. You, my pal, ROCK! I found just the info I already searched all over the place and simply could not come across. What an ideal web-site.

  255. I have been exploring for a bit for any high-quality articles or blog posts in this kind of house . Exploring in Yahoo I ultimately stumbled upon this web site. Studying this information So i’m happy to show that I have an incredibly good uncanny feeling I came upon just what I needed. I such a lot for sure will make sure to don’t forget this site and provides it a look on a relentless basis.

  256. Hi there! This is kind of off topic but I need some advice from an established blog. Is it very hard to set up your own blog? I’m not very techincal but I can figure things out pretty quick. I’m thinking about making my own but I’m not sure where to start. Do you have any ideas or suggestions? Many thanks

  258. I’ve read a few just right stuff here. Certainly value bookmarking for revisiting. I wonder how a lot effort you place to create this type of fantastic informative website.

  259. Hello! Someone in my Myspace group shared this site with us so I came to take a look. I’m definitely loving the information. I’m bookmarking and will be tweeting this to my followers! Fantastic blog and great design.

  260. I’m really enjoying the design and layout of your blog. It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a designer to create your theme? Excellent work!

  262. This is the right blog for anyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I actually would want…HaHa). You definitely put a new spin on a topic thats been written about for years. Great stuff, just great!

  263. Along with almost everything that seems to be building within this particular area, your viewpoints tend to be fairly exciting. Nonetheless, I beg your pardon, because I can not subscribe to your entire theory, all be it radical none the less. It seems to everyone that your opinions are not entirely validated and in simple fact you are your self not completely confident of your assertion. In any case I did enjoy looking at it.

  266. Woah! I’m really enjoying the template/theme of this site. It’s simple, yet effective. A lot of times it’s hard to get that “perfect balance” between superb usability and appearance. I must say you’ve done a superb job with this. Also, the blog loads very fast for me on Internet explorer. Outstanding Blog!

  269. I’ve learn some just right stuff here. Definitely price bookmarking for revisiting. I wonder how so much effort you place to make one of these fantastic informative web site.

  270. I have been surfing online greater than three hours these days, but I never discovered any attention-grabbing article like yours. It is beautiful price enough for me. In my opinion, if all website owners and bloggers made just right content as you did, the net can be a lot more useful than ever before. “I thank God for my handicaps, for through them, I have found myself, my work and my God.” by Hellen Keller.

  271. Thank you for some other great post. Where else may just anybody get that type of info in such a perfect approach of writing? I’ve a presentation next week, and I’m on the look for such info.

  272. I just could not depart your site prior to suggesting that I extremely enjoyed the usual information a person supply in your guests? Is gonna be again frequently in order to check out new posts.

Leave a Comment