|
Featured Tutorial
Featured Macro
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
Create Names From Selection