Password-protect a spreadsheet

It can be useful to protect an Excel spreadsheet with a password, for example before sending it by e-mail. Password-protected files are also encrypted, so there’s no way of seeing their contents without knowing the password.

You can do the same with Word documents. The process is virtually identical to that described below for Excel.  Access databases can also be password protected, although it’s a little more complicated (look for File | Info | Encrypt with Password).

Here are step-by-step instructions for putting a password on an Excel spreadsheet. Continue reading Password-protect a spreadsheet

Freeserve E-Mail to End

Anyone with an email address from Freeserve, Orange, or Wanadoo will find that it doesn’t work after 31st May 2017, and they won’t be able to access their account or send or receive emails.

Freeserve was bought by Orange years ago, and then Orange was bought by EE and now EE is part of BT. So the current owners have decided to shut down all the old email systems they have inherited.

Their explanation (and a full list of the affected email systems) is here.

If you want to know what your options now are, get in touch with me (preferably by e-mail to paul1@pdoc.co.uk) and I’ll try to help.

How do I know if an email is genuine?

Sooner or later you’ll get an email telling you you’ve won the lottery, ordered something you don’t remember ordering, missed a delivery, are due a tax refund, or that you need to “verify your account”. How do you know if you can trust these emails or not?

The first thing to know is that you can’t trust who the email says it’s from. Here’s a message from my spam folder:

It says it’s from someone called “Track My PPI”, whose email address is sigint@app.topica.com. Maybe it is, maybe it isn’t, but I can’t tell from the email address that is shown.  This is no more reliable than the address written at the top of a paper letter – it’s created by the sender. If they are dishonest, it may well be a lie. Just because it’s “the computer” doesn’t make it true. Continue reading How do I know if an email is genuine?

How do I know if a website is genuine?

Click to enlarge

Sooner or later everyone gets an email saying you have to “verify your account” and warning of the dire consequences if you don’t. These are always a scam.  No-one genuine will ever ask you to verify (or “re-verify”) your account. Sometimes you might have to verify your email address (by click on a link in the email) but you’d never have to verify your account. Here’s a screenshot (left) of a typical “verification” page. It says it’s from Apple, but it’s not.

You’d get to this site by clicking on a link in an email that “Apple” sent you. We’ll look at that in a later post, but for the minute let’s look at the web page. Continue reading How do I know if a website is genuine?

How to stop Microsoft Word from double-spacing everything

I get asked this a lot. Microsoft changed how Word initially works a version or two ago, and here I explain (with screenshots from Word 2016) what’s going on.

One feature of Word that new users tend to ignore is its “styles” function. Initially, Word uses the “Normal” style, but lots of other styles are available, for example the “No Spacing” style. To choose a style, just click it on the “Home” tab:

Click to enlarge

Continue reading How to stop Microsoft Word from double-spacing everything