Excel Name Manager Editing, Filtering &Excel Named Ranges makes it easy to refer to data sets in Excel You can create a named range in Excel for each data category, and then use that name instead of the cell references For example, dates can be named 'Date', Sales Rep data can be named 'SalesRep' and sales data can be named 'Sales'1 First, select the cell where you wish the range name to be pasted 2 In the Ribbon, select Formulas >
5 Ways To Create An Excel Named Range