Giving a nice, natural and human-readable name to a cell is important.
Creating and auditing formulas in traditional spreadsheet applications is time consuming and error prone because they are represented by abstract cell references (e.g., A2) and you may mistype them without realizing it.
Cell references also make it hard for you, let alone a colleague, to debug formulae or audit models.
This is why in Visyond you have the option of using descriptive natural cell names in formulas instead of cryptic cell references.
How to Assign a Natural Name to a Cell in Visyond
If your worksheet has labels for at least a row, Visyond will show the natural name in the following format:
Worksheet! RowName@RowNumber [ColumnName@ColLetter]
We use the “@RowNumber” and “@ColLetter to make names unique and allow you to easily find the cell location.
If [ColumnName] is not defined, then it will show:
Worksheet! RowName@RowNumber [ColLetter]
If you want to go back to a classic Excel environment you can toggle Off the Names button.
Working With Natural Names
We recommend that when you are debugging formulas and auditing models keep the:
- Audit Mode is On
- Natural Names is On.
- Precedents and Dependents is turned On.
When you click through the Visyond worksheet you will be able to spot any inconsistency in formulas, immediately figure out the precedent and dependent cells, and instantly determine which cells have comments, attachments, or cases.