Breadcrumbs

Naming cells/ranges in Excel

Overview

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


https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/3vjhlC0WTOiWWS1kjAM6gxTmrLARq2uWdw.png


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.