How To Name A Range In Excel?

Select the cell or range of cells you want to name

Click the Name Box to the left of the formula bar

Type the desired name

Press Enter

Or go to the Formulas tab

Click Define Name

Enter the name in the Name box

Choose the scope if needed

Click OK

Suggested for You

Trending Today