Click OK If you're using Excel 07 or 10 with the example sheet, do the following Click the Formulas tab In the Defined Names group, click Name Manager (IfThen, do one of the following On the Formulas tab, in the Defined Names group, click Define Name Rightclick on the selection and choose Define Name in the popup menu On the Formulas tab, in the Defined Names group, click Name Manager (or press CtrlF3 ), then in the Name Manager dialogHere's how Go to the Formulas tab > Defined Names group, click Name Manager Or, just press Ctrl F3 (my preferred way) In the top left hand corner of the Name Manager dialog window, click the New button This will open the New Name dialog box where you configure a name as demonstrated in the
Microsoft Excel Tutorials Named Ranges
Define name excel 2016