In Excel, named ranges are cell ranges, formulae, or constants that have been given user-defined labels or names. It is simpler to comprehend and deal with the data if you give a range of cells or a formula a meaningful name rather than just using the cell references (such as A1, B2, etc.).
The following steps can be taken to create a Named Range:
Select the range that you intend to give a name.
From Ribbon, select Formulas
Click on 'Define Name' from the 'Defined Names group'.
Give any name of your choice