If you’ve ever had a long list of inputs/outputs in your workbook and wanted to give them defined names based on their labels, then this is a tips you’ll definitely want to learn as it’s a lot quicker than naming them individually using the Name Box or Name Manager. Since spaces aren’t allowed in defined names, this method also replaces any space characters in your labels with underscores.  

  Use the Create from Selection command.  

  Just like that all your cells are nicely named using the labels to the left.

How To Create Multiple Defined Names Based On Labels In Other Cells - 29