Select the cell or range you want to name
Click the Name Box to the left of the formula bar
Type the name you want to assign
Press Enter
Use the Name Manager on the Formulas tab to create or edit names
Select a column header if you want to refer to an entire column
Enter a valid name that starts with a letter, underscore, or backslash
Avoid spaces and special characters in the name
Use underscores instead of spaces if needed
Confirm the name appears in the Name Box or Name Manager