Introduction to Excel

Names are unique within a workbook and the names that you choose to use must adhere to certain rules. ... Select the cell or cells containing the formulae whose references you want to replace with names. From the Insert menu, click Name and then Apply. The following dialog box will appear: ... and click the Formulas check box and OK. ................
................