Why create shorter calculations? They can be easier to read. This could mean 2 things, one is to make calculations more efficient so they run faster but the other is a phyically shorter line of calculation, that is what I am going to talk about today. This is not having to use file, sheet and cell references within the calculation.

Cells within Microsoft Excel are already named. A1, A2 etc this name is how we reference the cell within calculations and forumlae. Did you know that you could change these names and specify your own?

Now comes the question of why? There are too many cells within a spreadsheet that I would not want to count them or even calculate how many there are, I am sure there are a few numbers geeks out there who relish the thought of this task. You can also have multiple spreadsheets which means that if you have a cell that you want to use within many calculations on different sheets you will have to reference them with the sheet name and the cell. Your calculations can get a bit long.

By naming the cell to a unique name you can just use the name within calculations and references. For example if you type the VAT amount within sheet 1 in cell B3 you can change the name to VAT. If you were to then create a calculation with this cell you would not use the old cell name, but can use the new one. So =E10 * Sheet1!B3 could be =E10 * VAT a much easier calculation to use.

To create a named cell select the cell you would like to name and click into the name box. The name box is at the top left of the window, it is on the left of the forumula bar, this is the line above the heading that you can see the contents of the cell you have selected. Type in the name you would like to use, the main rule is no spaces allowed. I am going to call mine VAT then press the return key to save.

How can you tell if it has saved? Go to another spreadsheet and use the dropdown at the end of the name box, you will see a list of all the named items that can be selected. You should see VAT, click on it to select, and you will move to that location.

You can use this named range within formulae and calculations. If you are typing a calculation you can type the name in or if you forget what you called it or it is a long name and want to save time, then use F3 to show all named ranges. Select the desired named range.

There are a lot more you can do with named ranges, this is just a very basic use. Try it and see if you can save some time.