Excel Forum

Excel Magic Trick #138: Names Cell If Name in Cell

See how to name individual cells a name that is the cell content (the name of the cell is in the cell). To do this: 1) Put names in column B, 2) copy the names and paste them in column A, 3) highlight everything, 4) Ctrl + Shift + F3 and select "Left column", 5) Delete column A.

Create Names From Selection

Got a Question? Ask it Here in the Forum.