Skip to main content

How To Enable Password Protection In Ms Excel Files

By John Bennet
Protecting your computer user accounts with a password doesn't mean important files were really safe and secure if anyone who has the privilege to access your user account is free to view and make changes by default, in spreadsheet application called Excel developed by Microsoft. Microsoft has designed this spreadsheet application, which has several features such as calculating, graphing tools, pivot tables, etc.

Sharing desktop is not the only threat to excel files when you send excel files online via email to a group of mates that you want to share with, but sent to an unknown mail id by mistake, which has confidential information that shouldn't be disclosed. To prevent such situation add password's to Excel files and limit the user from making changes and viewing, with the right password.

Read Also: How to make your computer speak whatever you type with notepad.

Why Add a password for excel file?  When you have one for the computer.
It's better to protect an excel file with a separate password distinct from the user account password, just like a house with a key, which is distinct from the safe key. You can limit/control user access to excel file in two ways.
  1. Protect excel file from viewing 
  2. Limit user access from making changes to excel file

To Protect Excel With Password From Viewing:

By default, everyone is allowed to view the document, but to restrict unauthorized users from opening the excel file with password either offline/online.
Just follow the steps below to allow users just to view.
  1. Open MS-Excel
  2. Go to: Office button->Prepare->Encrypt Document.
  3. A window pop up's to enter a password, enter any password and re-enter to confirm the password.
  4. Once you have set the password, save the file to add a password.
NOTE: To remove the password and let anyone access the file, repeat the above steps and remove the existing password from Encrypt document pop up window and click ok.
    How to Allow User To Save Changes In MS-Excel:
                            With this option you can limit user priority, from making changes and saving the existing excel, to do so follow the steps below.
      1. Open Microsoft excel.
      2. Tab to review on the menu bar and click allows the user to edit changes.
      3. A window pop up's in there click protect the sheet.
      4. Again another pop-up window open's requesting a password, select the checkbox below to allow the users to make additional changes if required.
      5. Now re-enter the password to confirm the changes.
      6. Once password set, save the file.
      Note: Sharing desktop with other's will let them delete the excel files, but prevent them from making changes and viewing if password protection enabled. 

      Labels

      Labels:

      Comments

      Post a Comment

      Popular posts from this blog

      How to Disconnect Bsnl BroadBand and Landline Services Online

      By John Bennet
      Most of the service providers and executives are experts in facilitating the procedures on how to avail the service but will keep their service termination procedures around the corner which will make it difficult for the users to switch on to other networks immediately and easily. Did you know there are people who rely on their faulty landline/broadband connection simply for the complex procedures and time it would take to close the faulty connection? But here in this blog, we have grabbed the termination process from around the hidden corners of the Bsnl portal to facilitate the Bsnl phone disconnection process in simple steps. Note: You can be an existing BSNL customer for years, however, it is mandatory to have an online account registered in the BSNL customer relationship management(CRM) self-care portal to access the online services. If you don't have one, create one by clicking on the below respective links to access your region Bsnl self-care portal for account mana...
      Post a Comment
      Read more

      How to Turn-Off Auto Correct in WhatsApp & Other Messengers

      By John Bennet
      Dictionary is not only for the people who don't understand the meaning of a word but also used to know the spelling of a word because there are certain words that may phonetically sound the same but spell differently. Using short forms/abbreviated terms during chats is common among teens of this generation for an easy and fast way to communicate and convey information to anyone in contact. Though most of the short forms are auto-added in Messenger dictionary by default but short forms are extended day by day which interfere while typing to project a sentence but eventually auto-corrected to something else by the android keyboard bots. Also Read: How to Play iPhone(.mac) video format files in Android  How to Turn ON/Off Predictive Text While Typing in Messenger? Did you know! Text auto-correction is not a distinctive feature of Whatsapp, the WhatsApp or in any other social messenger's typewriter will be incorporated with either the Android default keyboard ...
      Post a Comment
      Read more

      How to Register and Activate SBI Internet Banking Online

      By John Bennet
      Internet Banking is the most trusted and efficient way of making transactions, bill payments, view accounts, view statements, deposits and many more facilities that can be accessed from any corner of the world for free. To avail these facilities in SBI (or) any  State Bank Groups new customer's will be given the PPK kit along with the passbook at the time of creating accounts in the bank itself if the internet banking facility request was mentioned in the Account opening form, but for existing customer's they have to register separately to get access to the internet banking either by visiting a branch or without visiting a branch. Also Read:   10 safety tips for secure banking online - That You Must Know If the main motive of internet banking is to ease transactions and payments for clients in the leisure, without visiting a bank home branch in person, then why not to make the registration and activation process of internet banking also in the leisure from their ...
      81 comments
      Read more