Visyond Help Home
  1. Home /
  2. I would like to... /
  3. Audit or debug the spreadsheet /
  4. How to use Natural Names in Visyond
  1. Home /
  2. Tips and shortcuts /
  3. How to use Natural Names in Visyond
How to use Natural Names in Visyond

How to use Natural Names in Visyond

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 formulas 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 Turn Natural Names On/Off

To turn Natural Names on/off, click the button Names in the top right corner:

How to Assign a Natural Name to a Cell

To add a name for row 2, simply type the name for this row in the first column (A):

To add a name for column B, type the name for this column in row 1:

Now, when you refer to cell B2 when Natural Names are turned on, Visyond will transform B2 into MyRow@2[MyColumn@B]:

How It Works?

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]

E.g., 2!Revenues@3[2016@B]

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]

E.g., 2!Revenues@3[B]

 

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.

how to
January 15, 2020

Was that post helpful?

Related Articles