Excel Forum
Similar Content
OR Function - Check if Any Argument is True
Tutorial: The OR function in Excel checks if ANY argument in it evaluates to TRUE.  If anything eva...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
FV Function - Get the Future Value in Excel
Tutorial: The Future Value function (FV) in Excel will return the future value of an investment ba...



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.