In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell which you have given a custom name to.
It is important to note that certain symbols will not be permitted including spaces. In the above example I used an underscore (_) instead of a space. This window will pop-up if the Name you entered is invalid.
This helps you keep track of all the Named cells/ranges within your current workbook. You can see all the Names you have created as well as the cells/ranges they refer to. Double click on a Name to edit it or alternatively select the Name then click the Edit button.
You can also delete a Name by selecting it then click the Delete button.
You can also define Names and use them in formulae by using the Define Name and Use in Formula buttons on the Formula Tab. Define Name is also available when you select a range of cells and right-click. This opens a New Name pop-up similar to the Edit Name pop-up.
You can also alter the scope of your Names. In the above example I have kept the scope of the TotalTax Name to Sheet1. This means that the TotalTax Name can only be accessed/referred to on Sheet1. If you go to Sheet2 and try to use the TotalTax Name it will not be recognized. If the scope of the Name had been set to Workbook then the TotalTax Name would have been accessible from anywhere in the Workbook.
You can also enter a message in the Comment box above and that will display when you go to enter the Name into a formula or function in Excel.
Dont forget to download the file for this tutorial so you can follow along and see how everything works.