Naming cells/ranges in Excel
Avoid using the names of Excel or Velixo functions
Harry Lewis avatar
Written by Harry Lewis
Updated over a week ago


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.

Do not use function names

We must never give a cell or a range a name that matches an Excel or Velixo function name. This can result in Excel errors and/or inconsistent/incorrect results in our wookbooks.

Did this answer your question?