Naming cells/ranges in Excel

Overview

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


Excel Name Box showing a custom name assigned to a selected cell range


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

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.