The procedure from our first example, in which we let Excel have the name automatically, is the fastest procedure, but of course not always what is needed.
Basically, you can give each cell in Excel a unique name in 2 ways:
- About the name manager
- Directly via name field (to the left of the edit line)
We have now changed our example so that we have entered the VAT rate in a separate cell, off the turnover table, and this named the “tax”.
You can name a cell using the Name Manager as follows:
- Under “Formulas” – “Name Manager” click on “New”
- Give the cell an arbitrary name
- Set the cell in question
- Confirm with OK”
See picture (click to enlarge)