Naming worksheet cells
Naming worksheet cells allows you to reference a cell or block of cells by way of a Name that you assign instead of a cell reference. You can use Names and cell references interchangeably in your spreadsheets. Excel offers four ways to assign Names to cells: Name Box, Create from Selection, Define Name, and Name Manager. There are a couple of rules to keep in mind:
- Names must begin with a letter, underscore (
_), or backslash (\), so2024TAXis not a valid Name. - Names can be as short as a single letter, but you cannot assign the letters C or R as a name. This is because you when type
Cin the Name Box and press Enter Excel will select the current column, whileRand Enter selects the current row. - Names cannot be the same as any cell reference, such as
TAX2024. The last column in an Excel worksheet is XFD, so combining a word with one to three letters and a number together will constitute an invalid name. - Names cannot contain spaces, so
TAX...
