Open the excel sheet where you would like to create the named range.

Select the cells you would like to include in the named range.

Once the cells have been selected, click on the "Name Box".

Give the range a name. You can not use spaces or most punctuation marks. Names must start with a letter, underscore, or backslash. 

You should now see the name of the range in the "Name Box".

Office

This guide provides step-by-step instructions on how to create a named range in Excel. By creating a named range, users can easily refer to a specific group of cells in their spreadsheet, making it more efficient and organized. This guide also includes instructions on how to delete a named range and provides additional tips for using the Name Box feature in Excel.

Creating a Named Range in Excel