If you employ a estimator , you probably have some Microsoft Excel documents on your Mac or personal computer that you would n’t desire other people to find and read .
After all , Excel serves not only the mean someone , but also business , government mental hospital , and gazillion of other folks worldwide . Whatever you’reusing Microsoft Excelfor , the skilful means to keep that information safe is to learn how to password - protect an Excel data file .
Adding a password
Whether you’recreating graphical record in Excel , creating a pivot table , or just inputting row and rows of data point , password - protecting your data is n’t just a skillful idea , it ’s also easy .
tone 1 : In Excel , start the document you want to secure with a password .
Step 2 : ClickFile , watch byInfo .
dance step 3 : Next , click theProtect workbookbutton . From the drop - down menu , selectEncrypt with password .
Step 4 : Excel will then inspire you to type in a parole . Pick one that ’s complicated and unparalleled and note it down in a qualitypassword manager .
File encryption
Now that you ’ve watchword - protected your most indispensable file , it might be worth considering adding supererogatory layers of security system to your arrangement . The comfortable way to protect a big number of records is to code them . Luckily , encoding programs are not hard to see . Windows 10 Professional users have a built - in encryption utilitycalled BitLocker . Still , if you want to download a complimentary version with customization options for different types of data , you’re able to try theVeraCryptopen root download .
Additional security options
Excel also allows you to apply morecustomized security optionsto your data file if necessary . It ’s crucial to recognize what these other options do so you’re able to create the correct security measure for your project . UnderProtect workbook , you ’ll find several additional features that may prove utilitarian :
Mark as last : This will score the file as completed , which lets other people know that they should n’t make any variety . Using this option will not secure the data point behind a password , however , so it does n’t offer any certificate .
Protect current sheet : This will guard the currently selected worksheet with a word so that mass ca n’t make any change or only certain kinds of changes . It ’s a ready to hand option if there ’s only one sheet in the workbook that you want to protect , and you do n’t mind if people can see the information — you just do n’t want them mess up with anything . You will comment that there ’s also an option to do this withWorkbook structure , which protect from larger changes to the workbook ( like add a novel shroud ) , unless people have the password .
sum a digital signature : you’re able to vouch that only you have approach to and assure over your Excel files by adding a digital signature .
safeguard Excel file is a of the essence job that many citizenry overlook . There are plenty of safety measures available to ensure that your information remains private and secure , starting with password protection .
But if all this seems like overkill , you have less extreme options to protect your worksheet . For lesson , you might prefer tolock cells in Excelto halt them being accidentally altered .
