STEP 1

FIRST, THINK OF A word with four different letters. We're going to use the word 'bank'. It's important not to reveal your own word to anyone else. Now launch Excel. We're using Excel 2007, though our instructions will work in all recent versions of the program,or even in other spreadsheet programs. Begin by entering the first few letters of the alphabet into the first column, going no further than G.Continue in the third column (column C) up to N and follow on in alternate columns until you've written out the whole alphabet,as per our screenshot. You don't have to follow our example exactly, though when complete the total area should be roughly about the size of a credit card.

STEP 2

ONCE YOU'VE LAID OUT the letters in this way, ensure that they're legible by checking in Print Preview. In Office 2007,c1ick the Office button, followed by Print then Print Preview. In earlier versions of Excel, Print Preview is found in the File menu. Close Print Preview and, if deemed necessary, adjust the font and point size of the letters entered. The card needs to be easily read to avoid fumbling and squinting at the cash point or check out. A quick glance should be all that's needed to read the Pin.

STEP 3

IN THE CELLS NEXT to the letters that make up the selected four¬letter word, enter each digit of the Pin. Assuming that'bank' is the chosen code word and the Pin is '9331: put 9 in the cell next to the letter B, 3 next to A, another 3 next to Nand 1 alongside K.This provides an easy way to look up the Pin using the code word. Now it's important to enter numbers in the cells next to every other letter so that no one else can read the Pin from this card. We'll get Excel to generate random numbers.

Name: Use Excel to create secure reminders.jpg Views: 130 Size: 40.4 KB

STEP 4

CLICK IN THE FIRST empty cell next to a letter not included in the code word.Type the formula =RANDO*1 0 into this cell and press Enter.Select the cell again and choose Copy on the toolbar or select Edit, Copy if the icon isn't shown. In Excel 2007the copy icon is in the Home tab of the ribbon. Alternatively,just use the keyboard shortcut Ctrl and .


STEP 5

SELECT THE REMAINING EMPTY cells and paste the formula into them. Choose Paste from the Edit menu,orthe paste icon from the toolbar orthe Home tab of the ribbon, depending on the version of Excel used.Alternatively,just hold down Orion the keyboard and tap V. As things stand, the numbers generated by the formula we've used may include decimal places.This would be a dead giveaway, so we need to limit the generated results to whole numbers. Select the whole sheet and choose Numberfrom the Home tab, followed by number formats, Number.ln earlier versions of Excel pick Number from the Format menu. Change the number of decimal places to zero and click OK.

STEP 6

PRINT THE SPREADSHEET and cut out the section including the letters and numbers. Stick this on a card to carry around in your wallet. Refer to the card and use the code word to remind you of your Pin when needed. We'd also suggest deleting the file used to generate the card, as this could potentially reveal the Pin if someone looks for the numbers that aren't generated randomly. Create a new card for each Pin.There's no need to change the code word, but ensure that each card is a different colour to tell them apart.