Help

A Doofa is a little gadget that makes everyday tasks on your computer quicker and easier. Whether you're tidying up address lists, organising accounts or writing repetitive computer code, you click on a button or two and Doofa does the rest.

Doofa works in harmony with Microsoft Excel. Each Doofa performs a different task.

Once downloaded, Doofas appear in the Excel toolbar and help make complex tasks quick and easy to complete.

Doofa products are created and sold by Sunfire Consultancy Ltd, New Zealand. Click here for company information.

Doofa is a registered trademark.

You! Only clever clogs have the good sense to download a Doofa!

Don't be a doofus, get help from a Doofa!

Doofa products help us to use some of the functions of Microsoft Excel that may otherwise go unused. Because these functions are often difficult to understand, people tend to shy away from using them.

Doofas are jargon-free and very easy to use. So you get more out of Excel without the headache!

Yes, provided you have a basic understanding of Microsoft Excel.

Doofa products are designed to be used by even the most inexperienced computer user. They are jargon-free and ever so simple to use.

Doofa is a play on the words 'do' (Doo) and 'for' (fa).

It is called Doofa because it will do a task for you.

To download and install Doofa...

You will need internet access to download the Doofa Installer and complete the activation process.

To use Doofa...

You will need one of the following computer operating systems:

• Window XP (Service Pack 2 or later)

• Windows Vista

• Windows 7

• Windows 8

• Windows 8.1

• Windows 10 (although it has not been extensively tested for this version)

...and one of the following versions of Excel:

• Excel XP/2002 (v10.0)

• Excel 2003 (v11.0)

• Excel 2007 (v12.0)

• Excel 2010 (v14.0)

• Excel 2013 (v15.0)

• Excel 2016 (v16.0)

Doofa does not work with Excel Starter as this is a simplified version of Excel.

Doofa will work with versions of Office 365 if they are installed locally on your computer but is not compatible with the online version of Office 365.

To run a Doofa, you will need one of the following operating systems:

Window XP (Service Pack 2 or later)
Windows Vista
Windows 7
Windows 8
Windows 8.1
Windows 10 (although it has not been extensively tested for this version)

Doofa is compatible with the following versions of Excel:

Excel XP/2002 (v10.0)

Excel 2003 (v11.0)

Excel 2007 (v12.0)

Excel 2010 (v14.0)

Excel 2013 (v15.0)

Excel 2016 (v16.0)

Doofa does not work with Excel Starter as this is a simplified version of Excel.

1. Open Microsoft Excel

2. Go to the toolbar at the top of the screen and select Help

3. A menu will drop down. Select About Microsoft Excel

4. A box will open which contains information including your version of Excel.

You need Address Spritzer. This will help you organise parts of an address list, such as house number, street, town, country and postcode. For example, you could split addresses shown in a single column into separate columns or pick out all the addresses in a particular town.

If you'd like to split first names and last names that are shown in the same cell/column try using Split Kit

You need a ColorCalc ColorCalc allows you make calculations based on the colour of cells.

For this, you'll need Combo Gumbo. Choose one set of cells and then another, and Combo Gumbo will combine them for you so they appear in a single set of cells.

Split Kit will separate the contents of a cell or a set of cells. It can split the contents where punctuation such as a space or comma appears. Alternatively Split Kit can just select numbers, just letters, or a specific part of a cell – for example, the third and fourth digits.

Often when you import a set of numbers into Excel, the leading zeros (the noughts at the start of the number) disappear. Zero Hero will add them back in for you.

We're in the process of designing many more Doofas and we'd love to hear your suggestions.

Contact us to suggest a Doofa.

Use LocCroc to securely store all your passwords and other sensitive information in an Excel spreadsheet.

You can buy The Whole Caboodle to have access to all Doofas.

Alternatively, select the Doofas you would like and add them to the cart individually.

If you would like to purchase Doofa for more than one person:

• Add The Whole Caboodle to the Cart. Then select the number of licences you need at the Checkout.
• If you're purchasing individual Doofas you can only buy one licence at a time. You'll need to make a separate purchase for each licence, with a new email address each time.

If you already have Doofas installed on your computer, you currently can't add additional Doofa products. We're working on making this possible, but in the meantime please contact us if that's what you'd like to do.

Downloading and installing Doofa is a quick and simple process:

Click on the download link to download the Doofa Setup file (The link is sent to you via email when you purchase Doofal. You can also access this link by logging in to this website)

To install Doofa Run the DoofaSetup.msi file (you may need to save it before you can run it)

Open Microsoft Excel

Enter the licence key when prompted (The licence key is sent to you via email when you purchase Doofal. You can also access the licence key by logging in to this website)

Locate Doofa in the Excel toolbar menu

Click on any Doofa to open it

Smile! With Doofa, work is going to get a whole lot easier!

When you have made your purchase you will be sent a link to download Doofa.

Click on this link and your computer will start to download the Doofa installer.

You may be asked if you would like to save the download.

If this is the case, click Save and, if you're prompted to do so, indicate where you would like the Doofa installer to be saved.

You could save this file in the Downloads folder or onto your computer's Desktop. The important thing is to remember where you have saved the Doofa Setup file.

If while installing Doofa, you receive an Access is Denied error message, this article may help you in troubleshooting the issue.

To check the Doofa Installer has successfully downloaded, navigate to the Downloads folder (or the place where you saved the Doofa Setup file. You should see a file called DoofaSetup.msi.

See Installing Doofa for the next steps in the download and install process.

1. To install Doofa, first you need to download the Doofa Setup file (To access the Doofa Setup file click on the link sent to you via email when you purchase Doofa. You can also access this link by logging in to this website).

2. Once the Doofa Setup file has been downloaded, navigate to the folder on your computer where it has been saved (e.g. the Downloads folder).

3. Find the file called DoofaSetup.msi and double-click on it to begin the installation.

You may be asked whether you wish to 'run' this file. If this is the case click Run.

4. A screen will appear asking you to confirm whether you accept the terms of the Licence Agreement. Please read through the Licence Agreement text and confirm you agree by ticking the box next to 'I accept the terms of the Licence Agreement'.

5. Click on the Install button.

A screen will appear confirming that Doofa has been installed.

6. Click Finish

The final stage is to activate Doofa.

For more see:

How do I download the Doofa installer?

How do I activate Doofa?

Problems installing Doofa

After buying a Doofa, downloading the Doofa installer and installing Doofa, the final stage is to Activate Doofa. Here's how...

Open up Microsoft Excel.

A dialogue box entitled 'Doofa Activation' will appear.

Enter your Licence Key in the space provided.

Your unique Licence Key appears in the Subscription Confirmed page you were redirected to after making your purchase. It is also included in the confirmation email you were sent when you purchased the Doofa. For ease, you can copy (Ctrl + C) and paste (Ctrl +V) the licence code if you wish.

Click the Activate button. 

After a few moments, a dialogue box should appear with the words: 'Doofa activation successful'.

Click on the OK button.

Now that it is installed, Doofa will appear in the Excel menu bar.

Click on Doofa and the Doofa drop-down menu will appear.

You can now select and use Doofas from the drop-down menu.

If the Doofas in the menu are black they are installed and ready to use. If they are grey, they are either not yet available or you have not yet successfully downloaded them.

If you have experienced problems activating your Doofa and would like to try again, go to the Doofa menu and select Doofa Activation from the drop down.

You will be able to use Doofa from within the Excel.

Open up Microsoft Excel.

Depending on your version of Excel you will find Doofa at the top of the screen either:

> As one of the options in the File menu, or

> In the Add-Ins group in the Ribbon

The Doofa software itself will be stored with your other computer programs.

You can view or uninstall Doofa by going to your Control Panel, then Programs and Features.

Doofa will appear when you open up Microsoft Excel, at the top of the screen in the File menu or in the Add-Ins group in the Ribbon bar.

The software itself will appear in the Control Panel of your computer, under Programs and Features.

You can uninstall Doofa just as you would uninstall any program on your computer.

The method for uninstalling a programme may differ a little depending on which version of Windows you have. However, the basic method is as follows:

1. Open the Start menu (on Windows)

2. Go to your Control Panel, then Programs and Features. You'll see a list of the programs installed on your computer

3. Select Doofa from this list of programs.

4. Click Uninstall.

More information about uninstalling a program using Windows

Below are some issues you may encounter while installing Doofa along with some suggested solutions.

We will do our best to help with any problems you experience installing or downloading Doofa.

Contact us and we'll get back to you as soon as we can.

If you can, please take a screenshot of what you see. We may ask for this to help us identify and solve the problem.

Don't worry if you can't; simply take a note of where and when the problem arises and the wording of any error messages you see.

Details of the version of Windows and Excel you are running will also be useful.

If while installing Doofa, you receive an Access is denied error message, this article may help you in troubleshooting the issue.

When you start to download Doofa you may get the following message (or similar):

An app on your PC needs the following Windows Feature

.NET Framework 3.5 (includes .Net 2.0 and 3.0)

You can download the .NET Framework by clicking on Install this feature

What is the .NET Framework?

The .NET Framework is an integral part of many applications running on Windows, including Doofa. The .NET Framework may already be installed on your computer. However, occasionally you may need to enable the .NET Framework so the Doofa can run.

Using Windows 8 or Windows 8.1?

There is no download for the .NET Framework 3.5 for Windows 8 or Windows 8.1. This means you need to enable the .NET Framework 3.5 using your computer's Control Panel. See below.

To enable the .NET Framework 3.5 in Control Panel:

1. On the Start screen, type and then choose Control Panel. (To access the Start screen, press the Windows logo key on your keyboard.)

2. Choose Programs, and then choose Turn Windows features on or off.

3. Select .NET Framework 3.5 (includes .NET 2.0 and 3.0) check box.

Click here for more information about installing the .NET Framework

To move Doofa over to your new computer you'll need to 'deactivate' it on your old computer.

Deactivating allows you to install a copy of Doofa on another computer and activate it. 

On your old computer:

1. Open up Excel

2. Go to the Doofa menu and select Deactivate

3. You can then uninstall Doofa if you wish

On your new computer:

4. Install Doofa (access the software by logging in to our website or by using the link you were sent when you subscribed to Doofa)

5. Open up Excel

6. Go to the Doofa menu and click Activate

Please make sure you have deactivated Doofa on your old computer before installing it on your new computer. Simply uninstalling Doofa won't deactivate it.

The Doofa Licence Agreement allows for two deactivations. So you will only be able two move your copy of Doofa twice.

This is to prevent misuse of the Doofa subscription.

Please contact us. We will reset Doofa so you can install it on your new computer.

Before you start working with any Doofa it is important that you take a backup copy of your Excel file.

The Backup page will remind you to do this.

Not everything Doofa does can be fixed using undo.

So it is best to play it safe!

In Excel go to File > Save As to make a copy of your file.

See below for a detailed description of how each part of Address Spritzer works

These help pages are best used while you have Address Spritzer open. The help topics are listed in the order in which they appear in Address Spritzer.

If you prefer, you can also use the Search at the top of the help page to find help on any aspect of Address Spritzer.

The Source page will ask you to indicate where in the spreadsheet you would like Doofa to look.

You will also be asked whether or not this selection has headings in the first row.

> Click and drag your mouse over the part of the spreadsheet you wish to select.

> Click Select.

> Details of the area you have selected will appear in the area at the centre of the Doofa pop-up box.

> Doofa will now only use the area you have selected.

> If you make a mistake, you can click Clear and make a new selection.

> Then you need to indicate whether the first row of the area you have selected contains headings, simply by clicking Yes or No.

> When you've done this, click Next to move on to the next stage.

On Address Spritzer's Source page you will be asked the question "Where in your spreadsheet would you like Doofa to look?"

In this case, you will want to select your address list (or the section of the address list you want to use).

> Click and drag your mouse over the address list.

This could be all or part of your spreadsheet.

If you wish, you can select a whole row or column.

> Then click Select.

> Details of the area you have selected will appear in the area at the centre of the Address Spritzer Source page.

> Address Spritzer will now only use the area you have selected.

> If you make a mistake, you can click Clear and make a new selection.

At the bottom of the Source page you will be asked:

"In the area you have selected are there headings in the first row?"

> Look in the first row of the area you have selected in your Excel spreadsheet.

> If this contains headings click Yes. If there are no headings click No.

Please note that if you have selected just part of the spreadsheet this is the first row of the area you have selected, not the first row of the entire spreadsheet.

Then click Next to move on to the next stage.

On this page, you will be asked: "which part of the address would you like Doofa to select?"

Address Spritzer allows you to seek out any of the following:

- Title

- Initials

- Name(s)

- House number

- Street address

- Town, county, state or country

- Postcode / ZIP code

- Email

- Telephone number

Please note that the Name(s) option in Address Spritzer will only identify names shown with a title or initial. If you'd like to simply split first names and last names please use Split Kit.

> Make your selection from the drop-down list

> When you've made a selection, you'll see below an explanation of how it works, along with some examples.

> Click Next to move on to the next stage.

Address Spritzer will identify the title(s) of one or more people:

For example:

Mrs Wallis Simpson, London

Mr & Mrs David and Victoria Beckham

Address Spritzer will then cut and paste or copy and paste these titles into a new column as you require.

Recognised titles:

Adm, Amb, Atty, Br, Capt, Cmdr, Coach, Col, Cpl, Dr, Dr, Earl, Fr, Gen, Gov, Hon, Lady, Lord, Lt, Lt Col, Maj, Master, Miss, Mr, Mrs, Ms, Msgr, Ofc, Pres, Prof, Pvt, Rep, Rev, Sec, Sen, Sgt, Sir, Sr, Supt.

This will identify a person's initials, whether they appear before or after a title or name. There must be a space or a full-stop (period) after each initial (commas won't work).

For example:

Mr J R R Tolkien

Johnson, L.B.,

Mr BA Baracus alias Mr T

Address Spritzer will then cut and paste or copy and paste these initials into a new column as you require.

Please bear in mind that if any other text in your address looks like some initials Address Spritzer may pick these up by mistake.

For example:

J. F. Kennedy Avenue

Address Spritzer will identify the name or names which appear before or after a title or initials.

There are various options:

- Name(s) after initial(s)

- Name(s) after title

- Names(s) with initial(s)

- Name(s) with title

- Name(s) with title and initials

Address Spritzer will then cut and paste or copy and paste these names into a new column(s) as you require.

To split two or more names, use the Customise option.

Address Spritzer will identify any name or names that come directly after initials.

For example:

- J.K. Rowling

- F Scott Fitzgerald

Address Spritzer will then cut and paste or copy and paste these names into a new column.

This is useful (albeit not perfect) for finding surnames.

There must be a space or a full-stop (period) after each initial (commas won't work).

Address Spritzer will identify any name or names that come directly after a title.

For example:

- Capt James T Kirk

- Dr  Leonard Bones McCoy

Address Spritzer will then cut and paste or copy and paste the name(s) into a new column as you require.

This is useful for finding a full name. To separate names, use the Customise option.

Recognised titles:
Adm, Amb, Atty, Br, Capt, Cmdr, Coach, Col, Cpl, Dr, Dr, Earl, Fr, Gen, Gov, Hon, Lady, Lord, Lt, Lt Col, Maj, Master, Miss, Mr, Mrs, Ms, Msgr, Ofc, Pres, Prof, Pvt, Rep, Rev, Sec, Sen, Sgt, Sir, Sr, Supt.

Address Spritzer will identify the initials, along with the name or names directly after the initials.

For example:

- Wile E. Coyote

- Mr J Edgar Hoover

Address Spritzer will then cut and paste or copy and paste the name(s) along with the initials into a new column as you require.

Both the initials and the name(s) will be cut/copied and pasted into a new column.

This is useful for finding a full name when no first name is present.

There must be a space or a full-stop (period) after each initial. (Commas won't work)

Address Spritzer will identify the title along with the name or names directly after the title.

For example:

- Sir Ranulph Fiennes O.B.E.

- Sir Ranulph Fiennes OBE*

- Mr Michael J Fox

*Note that initials without spaces appear as names.

The title and the names will then be cut or copied and pasted into a new column.

Recognised titles:

Adm, Amb, Atty, Br, Capt, Cmdr, Coach, Col, Cpl, Dr, Dr, Earl, Fr, Gen, Gov, Hon, Lady, Lord, Lt, Lt Col, Maj, Master, Miss, Mr, Mrs, Ms, Msgr, Ofc, Pres, Prof, Pvt, Rep, Rev, Sec, Sen, Sgt, Sir, Sr, Supt.

Address Spritzer will first identify the title and initials and then the name or names that appear after the title and initials.

For example:

- Mr S Holmes, 221 Baker Street, London

- Mr and Mrs B Fawlty, Fawlty Towers Hotel, Torquay

The title, initial(s) and name(s) will all be cut/copied and pasted into a new column.

Results will only appear if there is a title, initial and a name.

There must be a space or a full-stop (period) after each initial. (Commas won't work).

Recognised titles:
Adm, Amb, Atty, Br, Capt, Cmdr, Coach, Col, Cpl, Dr, Dr, Earl, Fr, Gen, Gov, Hon, Lady, Lord, Lt, Lt Col, Maj, Master, Miss, Mr, Mrs, Ms, Msgr, Ofc, Pres, Prof, Pvt, Rep, Rev, Sec, Sen, Sgt, Sir, Sr, Supt.

It is possible to use Address Spritzer to split names using the Customise option.

However, there is no completely reliable way of distinguishing a first name from a last name.

Consider the various ways the same name could be displayed:

In each of these examples, it is reasonably easy to work out where the names are, based on where they appear (after titles or before or after initials). However, you cannot be certain (especially in this case) which is the first name and which is the last name.

Want to split names which appear in a single column into two or more columns?

The best way to do this is to use Split Kit.

Address Spritzer will identify the house or building number within an address.

For example:

- 1619 Pine Street, Boulder, Colorado

- Mr Clark Kent - 344 Clinton Street, Apt. 3B

Address Spritzer will then cut and paste or copy and paste the building number into a new column.

Address Spritzer will identify the street within an address.

For example:

- 1313 Mockingbird Lane Mockingbird Heights, USA

The street will then be cut or copied and pasted into a new column.

To be identified by Address Spritzer the street must follow a house number.

Address Spritzer will recognise the following terms relating to a street address:

Walk, Road, Rd, Street, St, Hill, Rise, Court, The Park, Place, Pl, Crescent, Cres, Way, Green, Gn, Terrace, Tce, Lane, ln, Drive, Dr, Boulevard, Blvd, Avenue, Ave, Grove, Gr, Gate, Gardens, Gdns, Grdns, Square, Sq, Row, Junction, Quay, Mews, Grange, Track, Villas, Hospital, Hosp, Basement ,Bsmt, Close, Cl, Court, , Ct, Crt ,Cr

First you need to create a 'look-up list' of towns, cities, counties, states or countries.

This look-up list should contain the towns, cities, counties, states or countries you would like Address Spritzer to look out for.

Your look-up list should look something like this:

Note that in this example each county is in a new row with no blank rows in between.

Address Spritzer will use this look-up list to find information in your address list.

> Once your look-up list has been created, click and drag your mouse over it;

> Click Select;

Then continue to use Address Spritzer as normal.

Address Spritzer will identify the postcode/zip code within an address.

The postcode or ZIP code will then be cut or copied and pasted into a new column.

You can select from a number of postcode/ZIP code formats:

- New Zealand (NZ) postcode

- United Kingdom (UK) postcode

- United States of America (USA) ZIP code

- New Zealand (NZ) rural delivery number

Here are some examples:

- Auckland, New Zealand 1953

- 221 Baker Street, London NW1 6XE

- Beverley Hills 90210

- The White House
1600 Pennsylvania Avenue NW
Washington, DC 20500-000

- Lake Taupo, North Island, New Zealand, RD-1

Please note that if no postcode/zip appears in an address, Address Spritzer may pick up a house number by mistake, especially if it looks a little like a postcode. We're working to find a fix for this.

See below for a detailed description of how each part of ColorCalc works.

These help pages are best used while you have ColorCalc open. The help topics are listed in the order in which they appear in ColorCalc.

If you prefer, you can use the Search at the top of the help page to find help on any aspect of ColorCalc.

The Source page will ask you to indicate where in the spreadsheet you would like Doofa to look.

You will also be asked whether or not this selection has headings in the first row.

> Click and drag your mouse over the part of the spreadsheet you wish to select.

> Then click Select.

Details of the area you have selected will appear in the area at the centre of the Doofa pop-up box.

Doofa will now only use the area you have selected.

> If you make a mistake, you can click Clear and make a new selection.

> Then you need to indicate whether the first row of the area you have selected contains headings, simply by clicking Yes or No.

> When you've done this, click Next to move on to the next stage.

On the Source page you will be asked the question "Where in your spreadsheet would you like Doofa to look?"

This is where you show ColorCalc where it needs to look for the colours you select.

> Click and drag your mouse over the part of the spreadsheet you wish to select.

This could be all or part of your spreadsheet.

If you wish, you can select a whole row or column.

>Then click Select.

Details of the area you have selected will appear in the area at the centre of the ColorCalc Source page.

ColorCalc will now only use the area you have selected.

> If you make a mistake, you can click Clear and make a new selection.

At the bottom of the Source page you will be asked:

"In the area you have selected are there headings in the first row?"

> Look in the first row of the area you have selected in your Excel spreadsheet.

> If this contains headings click Yes. If there are no headings click No.

Please note that if you have selected just part of the spreadsheet this is the first row of the area you have selected, not the first row of the entire spreadsheet.

> Then click Next to move on to the next stage.

The Formula page is where you can tell ColorCalc what you would like it to do.

First you need to let ColorCalc know whether you wish to make one calculation or combine the results of two calculations.

In ColorCalc you can select from the following options:

- Make a single calculation

- Add the results of two calculations

- Subtract the results of two calculations

- Divide the results of two calculations

- Multiply the results of two calculations

Then you'll decide what you'd like ColorCalc to do with colours you select.

With ColorCalc you can:

- Add up the values to find a total

- Count the cells that are not empty

- Find the maximum value

- Find the minimum value

- Find the mean average value

> Make your selections from the drop-down lists then click Next to move on to the next stage.

ColorCalc is pretty clever.

On the ColorCalc Formula page you will see the words:

"Doofa can make one calculation or combine two calculations. What would you like Doofa to do?"

ColorCalc can just make a single calculation or combine the results of two calculations in a number of ways.

For example:

It could make a single calculation:

- Adding up all the numbers in cells with a blue background.

Or combine the results of two (or more) calculations:

- Adding up all the numbers in cells with a blue background.

- Then adding up all the numbers in cells with a yellow background.

- Multiplying the two totals together.

In ColorCalc you can select from the following options:

- Make a single calculation

- Add the results of two calculations

- Subtract the results of two calculations

- Divide the results of two calculations

- Multiply the results of two calculations

- You will find these options in a drop-down list on the ColorCalc Formula page.

If you struggle to get your head around this, why not try just making a single calculation to start with?

You can always progress to combining two calculations once you become more familiar with ColorCalc.

On the Formula page ColorCalc will ask:

"What would you like to do with the first colour you select?"

ColorCalc will ask this question before you've selected any colours.

So you'll need to keep in mind the colours you will be asking ColorCalc to look for. (You will be able to select the actual colours on the Colours page that comes next)

To answer this question, there are several options you can select:

- Add up the values to find a total

- Count the cells that are not empty

- Find the maximum value

- Find the minimum value

- Find the mean average value

If you're just making one calculation, this is the only colour you'll be working with.

If you're combining the results of two calculations, this is the first colour you'd like ColorCalc to work with.

> Make your selection from the dropdown list

> Click Next

For example:

You'd like ColorCalc to:

- Find the maximum value in cells with red text.

- Then find the minimum value in cells with green text.

- Then subtract one from the other.

So, you first want ColorCalc to do something with the red text.

The answer to the question: "What would you like Doofa to do with the (first) colour you select?" is the same as asking 'what do you want to do with the red text?'

So the answer is:

"Find the maximum value".

This question will only appear on the Formula page if you have asked ColorCalc to combine the results of two calculations.

You will be asked "What would you like to do with the second colour you select.

ColorCalc will ask this question before you've selected any colours.

So you'll need to keep in mind the colours you'll be asking ColorCalc to look for. (You will be able to select the actual colours on the Colours page that comes next).

There are several options you can select in answer to this question:

- Add up the values to find a total

- Count the cells that are not empty

- Find the maximum value

- Find the minimum value

- Find the mean average value

> Make your selection from the drop-down list

> Click Next

For example:

You'd like ColorCalc to:

- Find the maximum value in cells with red text.

- Then find the minimum value in cells with green text.

- Then subtract one from the other.

The second colour you'd like ColorCalc to work with is green. So you'll need to consider what you'll like ColorCalc to do with the green text.

Therefore, in answer to the question:

"What would you like Doofa to do with the second colour you select?",

you'd like to:

"Find the minimum value"

This is because the second thing you'll be asking ColorCalc to do is find the minimum value in the cells with green text.

The Colours page is where you select the colours you would like to use in your calculations.

It is also where you tell ColorCalc whether you'd like the calculations to be based on text colour or background colour.

> First, use the radio buttons to indicate whether you would like to base your calculation on the Text Colour or the Background Colour. 

> Then select your colour(s)

> Click on any cell in your spreadsheet which contains your chosen colour.

> Then click on the Click here to select the colour button

You'll see your chosen colour appear in the box below.

Notice that in the box below there is some text reminding you of the calculation you've asked ColorCalc to make.

Please note:

In some versions of Excel, ColorCalc will not work with grey text, grey backgrounds, or black text. Although it does work if the text colour is 'automatic' or any other colour.

In Excel 2007 ColorCalc will only work using 'Standard Colors'. 'Theme Colors' do not currently work with ColorCalc.

We're working on a fix for this.

On the Colours page in ColorCalc you will be asked:

"Which Colours would you like to use in your calculation?"

Text Colour or Background Colour?

> Use the radio buttons to show whether you would like to base your calculation on the Text Colour or the Background Colour.

Choose a Colour

To select your colour(s):

> Click on any cell in your spreadsheet which contains your chosen colour.

> Then click on the Click here to select the colour button

You'll see your chosen colour appear in the box below.

Notice that in the box below there is some text reminding you of the calculation you've asked ColorCalc to make.

Here is an example:

You'd like ColorCalc to find the maximum value of the cells with red text.

On the Formula page, you asked ColorCalc to find the maximum value.

Now you need to let ColorCalc know to look for red text.

So here's how:

> First use the radio buttons to select Text Color.

> Next, click on any cell in your spreadsheet which contains red text...

> Then click on the Click here to select the colour button

The red text colour will appear in the square below.

Made a mistake?

> Simply make your selection again and a new colour will appear in the box below.

If you don't select a colour at all, ColorCalc will simply make a calculation based on the default colour of your spreadsheet.

Making more than one calculation?

If the calculations you are making are based on two colours, you'll need to select both colours.

The first colour in your calculation appears on the left.

The second colour in your calculation appears on the right.

It is possible to select the text colour for one and the background colour for the other.

Please note:

In some versions of Excel, ColorCalc will not work with grey text, grey backgrounds, or black text. Although it does work if the text colour is 'automatic' or any other colour.

In Excel 2007 ColorCalc will only work using 'Standard Colors'. 'Theme Colors' do not currently work with ColorCalc. We're working on a fix for this.

On the Colours page in ColorCalc you will be asked:

"Which Colours would you like to use in your calculation?"

> Use the radio buttons to show whether you would like to base your calculation on the Text Colour or the Background Colour.
 

Here is an example:

You'd like ColorCalc to find the maximum value of the cells with red text.

On the Formula page, you asked ColorCalc to find the maximum value.

Now you need to let ColorCalc know to look for red text.

So here's how:

> First use the radio buttons to select Text Color.

> Next, click on any cell in your spreadsheet which contains red text...

> Then click on the Click here to select the colour button

The red text colour will appear in the square below.

Made a mistake?

> Simply make your selection again and a new colour will appear in the box below.

If you don't select a colour at all, ColorCalc will simply make a calculation based on the default colour of your spreadsheet.

Making more than one calculation?

If the calculations you are making are based on two colours, you'll need to select both colours.

The first colour in your calculation appears on the left.

The second colour in your calculation appears on the right.

It is possible to select the text colour for one and the background colour for the other.

Please note:

In some versions of Excel, ColorCalc will not work with grey text, grey backgrounds, or black text. Although it does work if the text colour is 'automatic' or any other colour.

In Excel 2007 ColorCalc will only work using 'Standard Colors'. 'Theme Colors' do not currently work with ColorCalc. We're working on a fix for this.

On the Results page in ColorCalc you will be asked:

"Where would you like the results to appear?"

> Simply click on a single cell to show where you would like your results to appear.

> Then click Select.

The details of your selection will appear at the centre of the Results page, showing which cell you have selected.

> If you make a mistake, simply click Clear and make your selection again.

> Once you've made your selection, click Next to move on to the next stage of ColorCalc.

> Click on a cell to indicate where you would like ColorCalc's results to appear.

You must select a single cell. This cell can't be in the same area where you asked Doofa to look for the colours (in the previous stage).

> When you've made your selection, click Select

> If you make a mistake, simply click Clear and make your selection again.

> Once you've made your selection, click Next to move on to the next stage of ColorCalc.

The Summary page is the final stage of ColorCalc where you can check what you have asked ColorCalc to do and preview the results.

> Once you have run through the Summary page and are happy with what you have asked ColorCalc to do, click on the Go button to place the results in the spreadsheet.

The table on the Summary page displays:

- Source: Where you would like ColorCalc to look.

- Color 1: The first colour you'd like ColorCalc to work with, along with the calculation to be made.

- Calculation: How you'd like to combine the two colour calculations (only shows if you asked ColorCalc to combine the results of two calculations).

- Color 2: The second colour you'd like ColorCalc to work with, along with the calculation to be made.

- Preview: A preview of the results.

> Once you have checked the Summary table and are happy with what you have asked ColorCalc to do, click on the Go button.

Quick as a flash, ColorCalc will post your results into the spreadsheet.

On the Summary page there are a number of useful buttons:

- Start again will take you right back to the start of ColorCalc while removing anything you previously entered.

- Add calculation allows you to ask ColorCalc to search for more information in addition to your previous request. So it will take you back to the start of ColorCalc leaving all the information in that you previously entered.

- Save allows you to save your current request for use in future. (You can retrieve this later by going to the Doofa menu in the Excel Toolbar, selecting Load Doofa, then selecting the file name of the ColorCalc request you saved)

- You can use the Back button or click on the words at the top of the page to navigate to previous stages of Address Spritzer to make any necessary changes.

> Once you have run through the Summary page and are happy with what you have asked ColorCalc to do, click on the Go button.

Quick as a flash, ColorCalc will post your results into the spreadsheet.

The Start Again button on the Summary page will remove all previous information you have entered into ColorCalc and bring you back to the first screen.

In the Summary page there is an Add Calculation button. This will bring you back to the first screen of ColorCalc, leaving in all the data you have previously entered into ColorCalc so you can add to your original search.

On the Summary page, you'll see a Save button.

This allows you to save your current ColorCalc request for use in future.

To retrieve a saved ColorCalc request:

> Go to the Doofa menu on the Excel Toolbar.

> Select Load Doofa.

> Then select the ColorCalc request you saved.

See below for a detailed description of how each part of Combo Gumbo works

These help pages are best used while you have Combo Gumbo open. The help topics are listed in the order in which they appear in Combo Gumbo.

If you prefer, you can also use the Search at the top of the help page to find help on any aspect of Combo Gumbo

The Source page will ask you to indicate where in the spreadsheet you would like Combo Gumbo to look for the first set of cells to be included in your cell combination.

You will also be asked whether or not this selection has headings in the first row.

> Click and drag your mouse over the part of the spreadsheet you wish to select.

> Click Select.

> Tell Combo Gumbo whether the first row of the area you have selected contains headings, simply by clicking Yes or No.

> Click Next to move on to the next stage.

On the Source page you will be asked the question "Where in your spreadsheet would you like Doofa to look for your first set of cells?"

This is the first set of cells which you will later combine with another set of cells.

> Click and drag your mouse over the area you wish to select.

This could be all or part of your spreadsheet.

If you wish, you can select a whole row or column.

> Click Select. Details of the area you have selected will appear in the area at the centre of the Combo Gumbo Source page.

> If you make a mistake, you can click Clear and make a new selection.

At the bottom of the Source page you will be asked:

"In the area you have selected are there headings in the first row?"

> Look in the first row of the area you have selected in your Excel spreadsheet.

> If this contains headings click Yes. If there are no headings click No.

Please note that if you have selected just part of the spreadsheet, this is the first row of the area you have selected not the first row of the entire spreadsheet.

> Click Next to move on to the next stage.

The Combo page will ask you to indicate where in the spreadsheet you would like Combo Gumbo to look for the second set of cells, to be combined with the first.

When the two sets of cells are combined, Combo Gumbo can separate the original contents with some punctuation, like a space or a dash.

The Combo page will allow you to choose what (if any) punctuation to use.

> Click and drag your mouse over the part of the spreadsheet where Combo Gumbo will find your second set of cells (to be combined with the first).

> Click Select. Details of the area you have selected will appear on the Combo page.

> Using the dropdown list below choose what punctuation you would like to use to separate the contents of your combined cells.

> Click Next to move on to the next stage.

On the Combo page you will be asked the question "Where in your spreadsheet would you like Doofa to look for your second set of cells, to be combined with the first?"

To make your selection:

> Click and drag your mouse over the area you wish to select.

This could be all or part of your spreadsheet.

If you wish, you can select a whole row or column.

> Click Select.

Details of the area you have selected will appear in the area at the centre of the Combo page.

Combo Gumbo will now combine these cells with the cells you selected on the Source page.

> If you make a mistake, you can click Clear and make a new selection.

When the cells are combined you can choose to separate the original contents with some punctuation.

> Go to the Combo page in Combo Gumbo.

> To separate the information use the dropdown list to select one of the following:

- No separator

- Comma (,)

- Colon (:)

- Dash (-)

- Forward slash (/)

- New line

- Pipe (|)

- Semicolon (;)

- Space

For example:

You would like to combine two sets of cells, the first containing first names and second containing last names.

When you combine them you'd like to add a space between the first and last names.

> To do this choose Space from the drop-down list on the Combo page.

Use the Results page to:

- Show Combo Gumbo where you'd like the results to appear

- Tell Combo Gumbo whether you'd like to cut and paste, or copy and paste the results.

Where would you like your results to appear?

> Click and drag your mouse over an area which is the same size or bigger than the area you selected on the Source page. (This is the area where you told Combo Gumbo to look for the first set of cells).

> Then click Select.

The details of your selection will appear in the text box showing which cells you have selected.

Copy and Paste or Cut and Paste?

You will then be asked:

"What would you like to do with your results?"

In the dropdown list select, one of the following:

- Copy and paste them

- Cut and paste them

Once you've made your selection, click Next to proceed to the next stage of Combo Gumbo.

In the Results page, Combo Gumbo will ask you where you would like your results to appear.

To make your selection:

> Click and drag your mouse over an area which is the same size or bigger than the area you selected on the Source page. (This is the area where you told Combo to look for the first set of cells).

If you wish you can select a whole row or column.

As your results will be placed here, the cells you select should be empty or they will be overwritten.

> Click Select.

You'll see some text appear on the Results page showing which cells you have selected.

> If you make a mistake, click Clear and make a new selection.

When Combo Gumbo finds the results you are looking for, you can choose whether to cut and paste them or copy and paste them.

- Cut and paste will remove the information from the original position and paste it into a new position.

- Copy and paste will keep the information in the original position, but also paste it into a new position.

On the Results page you will be asked:

"What would you like to do with your results?"

> From the dropdown list select, one of the following:

- Copy and paste them

- Cut and paste them

> Once you've made your selection, click Next to proceed to the next stage of Combo Gumbo.

The Summary page is the final stage of Combo Gumbo where you can check what you have asked Combo Gumbo to do and preview the results.

> Once you have run through the Summary page and are happy with what you have asked Combo Gumbo to do, click on the Go button to place the results in the spreadsheet.

The table on the Summary page of Combo Gumbo displays:

- Source: Where you have asked Combo Gumbo to look for your first set of cells.

- Combo: The location of the second set of cells you have asked Combo Gumbo to combine with the first

- Copy/Paste to: Where Combo Gumbo will place the results.

- Separator: What (if anything) Combo Gumbo will use to separate the combined cell contents. For example a space or comma.

- Cut/Copy: Whether the results will be copied and pasted, or cut and pasted.

- Preview: A preview of the results.

> Once you have checked the summary table and are happy with what you have asked Combo Gumbo to do, click on Go.

Before you know it, Combo Gumbo will combine the contents of your cells.

On the Summary page, there are a number of useful buttons.

- Start again will take you right back to the start of Address Spritzer while removing anything you previously entered.

- Combine more allows you to ask Combo Gumbo to combine more information in addition to your previous request. So it will take you back to the start of Combo Gumbo leaving all the information in that you previously entered.

- Save allows you to save your current request for use in future. (You can retrieve this later by going to the Doofa menu on the Excel Toolbar, selecting Load Doofa, then selecting the file name of the Combo Gumbo request you saved)

- You can use the Back button or click on the words at the top of the page to navigate to previous stages of Combo Gumbo to make any necessary changes.

> Once you have run through the Summary page and you are happy with what you have asked Combo Gumbo to do, click on Go.

Before you know it, Combo Gumbo will combine the contents of the cells.

The Start Again button on the Summary page will remove all previous information you have entered into Combo Gumbo and bring you back to the first screen.

On the Summary page there is a Combine more button. This will bring you back to the first screen, leaving in all the data you have previously entered into Combo Gumbo so you can add to your original combination.

On the Summary page you'll see a Save button.

This allows you to save your current Combo Gumbo request for use in future.

To retrieve a saved Combo Gumbo request:

> Go to the Doofa menu on the Excel Toolbar.

> Select Load Doofa.

> Then select the Combo Gumbo request you saved.

See below for a detailed description of how each part of Split Kit works.

These help pages are best used while you have Split Kit open. The help topics are listed in the order in which they appear in Split Kit.

If you prefer, you can use the Search at the top of the help page to find help on any aspect of Split Kit.

The Source page will ask you to indicate where in the spreadsheet you would like Split Kit to look.

You will also be asked whether or not this selection has headings in the first row.

> Click and drag your mouse over the part of the spreadsheet you wish to select.

> Click Select.

> Tell Split Kit whether the first row of the area you have selected contains headings, simply by clicking Yes or No.

> Click Next to move on to the next stage.

On the Source page you will be asked the question "Where in your spreadsheet would you like Doofa to look?"

To make your selection:

> Click and drag your mouse over the part of the spreadsheet you wish to select.

> This could be all or part of your spreadsheet.

> If you wish, you can select a whole row or column.

> Click Select.

Details of the area you have selected will appear on the Source page.

If you make a mistake, you can click Clear and make a new selection.

At the bottom of the Source page you will be asked:

"In the area you have selected are there headings in the first row?"

> Look in the first row of the area you have selected in your Excel spreadsheet.

> If this contains headings click Yes. If there are no headings click No.

Please note that if you have selected just part of the spreadsheet this is the first row of the area you have selected, not the first row of the entire spreadsheet.

> Then click Next to move on to the next stage.

The Split page is where you tell Split Kit how to split the cells you have selected.

You can:

- Extract letters or numbers

- Extract a section of each cell

- Split where punctuation is found

> When you make your selection from the drop-down list, further instructions will appear below.

> Once you've filled in the details, click Next to move on to the next page.

To extract just letters, just numbers, or both letters and numbers from each cell, go to the Split page.

> From the drop-down list select Extract letters or numbers.

> When you make your selection another drop-down list will appear below.

From this list you will have the following options:

- Extract letters only

- Extract numbers only

- Extract letters and numbers

> Once you've made your selection, click Next to move on to the next page.

Here's an example:

One of the cells contains the following content:

£123-ABC

These are the results you will see when you select each option:

Extract letters only:

ABC

Extract numbers only:

123

Extract letters and numbers:

123ABC

On Split Kit's Split page, you can choose to extract just a section of each cell.

> From the drop-down list select Extract a section of each cell.

>  When you make your selection the numbers 1234567890 will appear below.

> Click and drag your mouse over the section of each cell you would like to select.

When you do this you'll see that numbers appear next to Start, End and Length. You can use these numbers to confirm which section of each cell you have selected.

> Once you've made your selection, click Next to move on to the next page.

Here's an example:

You would like to select the third, fourth and fifth digits of each cell.

> So you click and drag your mouse over the 3, 4, and 5.

When you've done this, the numbers below will read:

- Start: 3 - start on the third digit

- End: 5 - end on the fifth digit

- Length: 3 - extract three digits

> If you prefer you can adjust these numbers to make your selection.

> Then you can click Next to move on to the next page.

Split Kit will allow you to split the contents of each cell wherever certain types of punctuation are found.

You simply tell Split Kit what punctuation to look for and the cell contents will be split automatically.

> In Split Kit, go to the Split page

> From the drop-down list select Split where punctuation is found.

> When you make your selection another drop-down list will appear below.

- Comma (,)

- New line

- Space

- Semi-colon (;)

- Colon (:)

- Pipe (|)

- Dash (-)

- Slash (/)

- Dot(.)

Once you've made your selection, click Next to move on to the next page.

From this list you will have the following options:

Some examples:

[Example 1]

In this example, the full names in the original spreadsheet (in column A) were separated using a comma.

Split Kit has used the comma to split the surnames and last names into two separate columns (columns B and C).

To do this choose Split where punctuation is found then select Comma (,).

[Example 2]

In this example, the two separate parts of each postcode have been split.

To do this choose Split where punctuation is found then select Space.

Use the Results page to:

- Show Split Kit where you'd like the results to appear

- Tell Split Kit whether you'd like to cut and paste, or copy and paste the results.

Where would you like your results to appear?

> Click and drag your mouse over an area which is the same size or bigger than the area you selected on the Source page.

> Then click Select.

> The details of your selection will appear on the Results page.

Copy and Paste or Cut and Paste?

You will then be asked:

"What would you like to do with your results?"

> In the dropdown list select, one of the following:

- Copy and paste them

- Cut and paste them

> Once you've made your selection, click Next to proceed to the next stage of Split Kit.

In the Results page, Split Kit will ask you where you would like your results to appear.

To make your selection:

> Click and drag your mouse over an area which is the same size or bigger than the area you selected on the Source page.

If you wish you can select a whole row or column.

As your results will be placed here, the cells you select should be empty or they will be overwritten.

> Click Select.

You'll see some text appear on the Results page showing which cells you have selected.

> If you make a mistake, click Clear and make a new selection.

When Split Kit finds the results you are looking for, you can choose whether to cut and paste them or copy and paste them.

- Cut and paste will remove the information from the original position and paste it into a new position.

- Copy and paste will keep the information in the original position, but also paste it into a new position.

On the Results page you will be asked:

"What would you like to do with your results?"

> From the dropdown list select, one of the following:

- Copy and paste them

- Cut and paste them

> Once you've made your selection, click Next to proceed to the next stage of Split Kit.

The Summary page is the final stage of Split Kit where you can check what you have asked Split Kit to do and preview the results.

> Once you have run through the Summary page and are happy with what you have asked Split Kit to do, click on the Go button to place the results in the spreadsheet.

The table on the Summary page of Split Kit shows you:

- Source: Where you have asked Split Kit to look.

- Split Type: whether you wish to extract just letters or numbers, extract a section of each cell, or split where punctuation is found.

- Results: Where your results will be pasted.

- Preview: A preview of your results.

On the Summary page, there are a number of useful buttons.

- The Start again will take you right back to the start of Split Kit while removing anything you previously entered.

- Add another split allows you to ask Split Kit to split more cells in addition to your previous request. So it will take you back to the start of Split Kit leaving all the information in that you previously entered.

- Save allows you to save your current request for use in future. (You can retrieve this later by going to the Doofa menu on the Excel Toolbar, selecting Load Doofa, then selecting the file name of the Split Kit request you saved)

- You can use the Back button or click on the words at the top of the page to navigate to previous stages of Split Kit to make any necessary changes.

> Once you have run through the Summary page and you are happy with what you have asked Split Kit to do, click on the Go button.

Split Kit with then split the contents of your cells - lickety split!

The Start Again button on the Summary page will remove all previous information you have entered into Split Kit and bring you back to the first screen.

On the Summary page, there is an Add another Split button. This will bring you back to the first screen of Split Kit, leaving in all the data you have previously entered into Split Kit so you can add to your original combination.

On the Summary page you'll see a Save button.

This allows you to save your current Split Kit request for use in future. 

To retrieve a saved Combo Gumbo request:

>Go to the Doofa menu on the Excel Toolbar.

> Select Load Doofa.

> Then select the Split Kit request you saved.

See below for a detailed description of how each part of Zero Hero works.

These help pages are best used while you have Zero Hero open. The help topics are listed in the order in which they appear in Zero Hero.

If you prefer, you can use the Search at the top of the help page to find help on any aspect of Zero Hero.

The Source page will ask you to indicate where in the spreadsheet you would like Zero Hero to look.

You will also be asked whether or not this selection has headings in the first row.

> Click and drag your mouse over the part of the spreadsheet you wish to select.

> Click Select.

> Tell Zero Hero whether the first row of the area you have selected contains headings, simply by clicking Yes or No.

> Click Next to move on to the next stage.

On the Source page you will be asked the question "Where in your spreadsheet would you like Doofa to look?"

To make your selection:

> Click and drag your mouse over the part of the spreadsheet you wish to select.

This could be all or part of your spreadsheet.

If you wish, you can select a whole row or column.

> Click Select.

> Details of the area you have selected will appear on the Source page.

> If you make a mistake, you can click Clear and make a new selection.

At the bottom of the Source page you will be asked:

"In the area you have selected are there headings in the first row?"

> Look in the first row of the area you have selected in your Excel spreadsheet.

> If this contains headings click Yes. If there are no headings click No.

> Please note that if you have selected just part of the spreadsheet this is the first row of the area you have selected, not the first row of the entire spreadsheet.

> Then click Next to move on to the next stage.

On the Zeros page ,you can use Zero Hero to add as many zeros as you like to the start of each number.

> From the drop-down menu select Tell Doofa how many zeros you would like to add.

Zero Hero will ask you: How many zeros would you like to add?

> Enter the number of zeros you'd like to add or use the up or down arrow select the number of zeros.

> You will see below how your results will appear.

> When you've made your selection click Next to move on to the next stage.

Zero Hero can add zeros so that each of the numbers in your spreadsheet has the same number of characters.

On the Zeros page:

> Select Add zeros to make the numbers a specific length from the drop-down list.

Zero Hero will ask you: How many characters would you like in each number?

> Enter the number of characters or use the up or down arrow select how many characters long you'd like each number to be.

> You will see below how your results will appear.

> When you've made your selection click Next to move on to the next stage.

Use the Results page to show Zero Hero how and where you'd like the results to appear.

When the zeros are added,  where would you like the results to appear?

> Make your selection from the drop-down list:

- In the original position

- In a new location

> Click and drag your mouse over an area which is the same size or bigger than the area you selected on the Source page.

> Then click Select.

> The details of your selection will appear on the Results page.

> When you've made your selection, click Next to move on to the next stage.

On the Results page Zero Hero will ask:

"When the zeros are added,  where would you like the results to appear?"

> Make your selection from the drop-down list:

- In the original position

- In a new location

> Click and drag your mouse over an area which is the same size or bigger than the area you selected on the Source page.

> If you make a mistake simply click Clear and make the selection again.

> Then click Select.

The details of your selection will appear on the Results page.

> When you've made your selection, click Next to move on to the next stage.

The Summary page is the final stage of Zero Hero where you can check what you have asked Zero Hero to do and preview the results.

Once you have run through the Summary page and are happy with what you have asked Zero Hero to do, click on the Go button to place the results in the spreadsheet.

The table on the Summary page of Zero Hero shows you:

- Source: Where you have asked Zero Hero to look.

- Split Type: whether you wish to extract just letters or numbers, extract a section of each cell, or split where punctuation is found.

- Results: Where your results will be pasted.

- Preview: A preview of your results.

> Once you have checked the summary table and are happy with what you have asked Zero Hero to do, click on the Go button.

Zero Hero will then add the zeros, quick as a flash!

On the Summary page, there are a number of useful buttons.

- Start again will take you right back to the start of Zero Hero while removing anything you previously entered.

- Add more zeros allows you to ask Zero Hero to split more cells in addition to your previous request. So it will take you back to the start of Zero Hero leaving all the information in that you previously entered.

- Save allows you to save your current request for use in future. (You can retrieve this later by going to the Doofa menu on the Excel Toolbar, selecting Load Doofa, then selecting the file name of the Zero Hero request you saved)

- You can use the Back button or click on the words at the top of the page to navigate to previous stages of Split Kit to make any necessary changes.

> Once you have run through the Summary page and you are happy with what you have asked Zero Hero to do, click on the Go button.

Zero Hero will then add the zeros, quick as a flash!

The Start Again button on the Summary page will remove all previous information you have entered into Split Kit and bring you back to the first screen.

On the Summary page there is an Add more zeros button. This will bring you back to the first screen of Zero Hero, leaving in all the data you have previously entered into Zero Hero so you can edit your original request.

On the Summary page you'll see a Save button.

This allows you to save your current Zero Hero request for use in future.

To retrieve a saved Zero Hero request:

> Go to the Doofa menu on the Excel Toolbar.

> Select Load Doofa.

> Then select the Zero Hero request you saved.

See below for a detailed description of how each part of LocCroc works.

These help pages are best used while you have LocCroc open. The help topics are listed in the order in which they appear in LocCroc.

If you prefer, you can use the Search at the top of the help page to find help on any aspect of LocCroc.

Here you will be asked to enter the password you wish to use to protect the data in your spreadsheet.

Please make absolutely sure you remember this password because it will be the only way you will be able to access this information in future.

You will also be asked whether you would like to lock or unlock the data in your spreadsheet.

> Enter your password

> Select lock or unlock

> Click Next to move on to the next screen

The Source page will ask you to indicate where in the spreadsheet you would like LocCroc to look.

> You will also be asked whether or not this selection has headings in the first row.

> Click and drag your mouse over the part of the spreadsheet you wish to select. 

If you are locking, you need to drag your mouse over the whole area you wish to protect. If you are unlocking, you don't need to select the whole area – you can click on any cell within the locked section.

> Click Select.

> Tell LocCroc whether the first row of the area you have selected contains headings, simply by clicking Yes or No.

> Click Next to move on to the next stage.

The Summary page is the final stage of LocCroc where you can check what you have asked LocCroc to do and preview the results.

You will see in the Summary table whether the area(s) of the spreadsheet you've selected is currently locked or unlocked.

> Run through the Summary page and check you are happy with what you have asked LocCroc to do

> Make 100% sure you will remember the password you've used (you won't be able to access locked data without it!).

> Click on the Go button to lock or unlock the data.

Once locked, it will be impossible to see or edit data in the locked areas. To access this data you will need to use LocCroc along with your password to unlock it.