How to Quickly Name Multiple Single Cells in Microsoft Excel

See Microsoft Excel: Tips and Tricks for similar articles.

You can quickly name cells in Microsoft Excel using their row and column headings.

This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.

  1. Select the rows and columns containing the range you wish to name. Selected Rows and Columns
  2. On the Formulas tab, in the Defined Names group, click the Create from Selection command. Create From Selection
  3. In the Create Names from Selection dialog box, check the desired boxes and click OK./ Create Names From Selection Dialog Box
  4. In the following image, cells can now be referred to using the row and column headings. Example