To prevent others from accessing data in your Excel files, protect your Excel file with a password. Note: This topic covers file-level protection only, and not workbook or worksheet protection. To learn the difference between protecting your Excel file, workbook, or a worksheet, see Protection and security in Excel. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.
Microsoft cannot retrieve forgotten passwords, so be sure that your password is especially memorable. There are no restrictions on the passwords you use with regards to length, characters or numbers, but passwords are case-sensitive. Be cautious when sharing files or passwords with other users. You still run the risk of passwords them falling into the hands of unintended users. Remember that locking a file with a password does not necessarily protect your file from malicious intent.
You can always ask an expert in the Excel Tech Community or get support in the Answers community. Protect a workbook. Step 4: Excel will then prompt you to type in a password. It is paramount that you remember it, or have access to a copy of it in a secure location because if you forget it, you will lose access to the Excel file and recovering it will be complicated.
From now on, any time you try to open that file, Excel will prompt you to input your newly chosen password. Note that this password only protects that individual document, not every Excel document on your PC.
If you want to see whether an Excel file has password protection or not, check out the Info tab for the document and look at the Protect Workbook section. It will tell you whether a password is required to open it or not.
The easiest way to protect a large number of records is to encrypt them. Luckily, encryption programs are not hard to find. Windows 10 Professional users have a built-in encryption utility called Bitlocker. Still, if you want to download a free version with lots of customization options for many types of data, you can try Crypto Expert 8 or VeraCrypt open source downloads.
Excel also allows you to apply more customized security options to your file if necessary. Don't send files unless requested; initial requests for help that arrive with attached files will be deleted unread.
You can send screenshots of your data to help clarify your question. When contacting me, be as specific as possible. For example, "Please troubleshoot my workbook and fix what's wrong" probably won't get a response, but "Can you tell me why this formula isn't returning the expected results? Please mention the app and version that you're using.
I'm not reimbursed by TechRepublic for my time or expertise when helping readers, nor do I ask for a fee from readers I help. You can contact me at susansalesharkins gmail. Be your company's Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets. Delivered Mondays and Wednesdays.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals. Watch Now. More about cybersecurity 10 ways ransomware attackers pressure you to pay the ransom Cybersecurity, the pandemic and the holiday shopping season: A perfect storm Why Windows 11's security is such a big deal End user data backup policy TechRepublic Premium. Microsoft Weekly Newsletter Be your company's Microsoft insider by reading these Windows and Office tips, tricks, and cheat sheets.
Delivered Mondays and Wednesdays Sign up today. Editor's Picks. Linux kernel 5. Windows Do these 11 things immediately. Top 5 things to do about your tech before you die. If you're not using a kanban board, you're not as productive as you could be.
0コメント