Naming cells/ranges in Excel

Created by Damien Zwillinger, Modified on Sun, 3 Sep, 2023 at 10:54 PM by Damien Zwillinger

Applies to:

Velixo NX
Velixo Classic
Every ERP

Overview

Excel provides the ability to give a cell (or a range of cells) an independent name:

We can then use that name is calculations, pivot tables, etc.

Important: Do not use Velixo function names for Names. Naming a cell or range as a Velixo function name can result in Excel errors and/or inconsistent/incorrect results in a workbook. Also consider not naming your cells in similar ways as Velixo, as Velixo may release new functions in the future.