causalitylabs.net

You have been working on this spreadsheet for a few nights already. Sacrificing dinner dates with friends just so you can finish it before your boss presents it to the board. You have congratulated yourself for a job well done even if your colleague did not even do his fair share for the report.

Now you look into your spreadsheet and see a blank page. Your boss has just tapped your door and requires the spreadsheet in five minutes. What do you do?

For important files like this, you need to find a way to secure your files. Question: How do I password protect an excel file?

It is very easy.

First, open a spreadsheet and go to Tools and click Options. A window will pop out. Go to the Security Tab. In that, there are two ways to password protect your file. You can either just share the file and do not allow others to modify it or no one can access the file without the password.

We have a bonus tip for wannabe Excel experts out there - how to connect worksheets in Excel? This is also known as linking worksheets. At times, you have various data available in different worksheets and you want to combine a set of data in just one worksheet. You can do that by using the equals (=) sign and then go to the desired cell in your worksheet then click ‘Enter’.

With these tips in hand, you will be considered an advanced Excel user in no time but of course, getting more training or using the ‘Help’ modules will further assist you on how to use this software more effectively. Have fun!