Learn something new every day!

Tag: Password

The most complete protection you can provide an Excel document is Password Encryption. It requires that someone have your password before they can open or view your workbook, and it is virtually bullet-proof. I’m not aware of any ways you can break into an encrypted Excel workbook, but I wouldn’t put it past some cyber-fiend to find a way! That being said, two critical cautions come to mind: Don’t forget your password. There is NO password recovery feature. Don’t give …

Encrypt Excel with a Password Read More »

Tagged with: ,

There’s a lot going on in the holiday season, and thieves and scammers like to take advantage of us when we’re not paying close attention. I received an email the other day that looked like it was from PayPal. Thank goodness I knew better than to click on any link in an email from a financial institution. If you look at the image, you can see one quick technique I use to check before I click on a link in …

Think Before You Click this Holiday Season Read More »

Tagged with: , , ,

The last tip I gave you was on how to protect parts of a Microsoft Word document. In this tip, I’m going to show you how to do the same thing in Microsoft Excel. The example I’ve got open on-screen has got two cell ranges (C12:O17 and C31:034) that we want people to be able to enter content into. The trick is to only allow people to enter content into those cells. Excel has a feature whereby all cells are …

Password Protecting Parts of an Excel Document Read More »

Tagged with: , , , , , ,