As formulas get more complex in Excel spread sheets it becomes essential that cells are named. It is a very simple process to name cells in Excel. After a cell has been named we can then refer to the named cell in subsequent formulas.

Naming a Cell in Excel

Simply double click  in the field that is shown in the image below.

Simple Named Cells Example

In this example we will name three cells, InterestRate, Balance and iEarn. After the cells have been named in cell iEarn enter the formula:

= InterestRate * Balance

Another Way you can use named cells is for navigation. Click on the button next to the name cell field and a drop down list of cells will appear. Simply select the desired cell and that region will become active.