Alternatively we can just press Ctrl F3 the shortcut for Name Manager For a new named range click on the New button. Select the data range you want to assign a name then Select Formulas and Create from Selection. Now press CtrlH and change the spreadsheet formulas or input range en masse.
You can download this Name Manager Excel Template here Name Manager Excel Template Go to Formulas tab Defined Names group then click the Name Manager.
Go get that espresso. Alternatively we can just press Ctrl F3 the shortcut for Name Manager For a new named range click on the New button. Select Formulas Create from Selection. Here is a good article that goes in-depth about the mixed cell references in Excel.