This week I'm working on a giant Excel workbook, and my client wants all the data entry cells named. There are about 600 cells to name, so I'm looking for ways to same some time.
A quick way to name a cell is to click in the Name Box, type the name, the press the Enter key. In the screen shot below, cell C4 is being named as FullName.
Create From Selection
Even quicker is to use the Create Names feature, and name the cells based on the labels in adjacent cells .
Here, the cells with labels, and
Continue reading Create Names From Excel Labels