It's a descriptive name — such as Jan_Sales or June_Precip — that is attached to a specific cell or range of cells in a worksheet or workbook Named ranges make it easier to use and identify data when creating charts, and in formulas such asSep 03, 18 · Here, when you enter the formula =Test in a cell, Excel returns "Hi There!" That is, names can define formulas that return text =SQRT(9) And here, the name Test returns the value 3, which is the square root of 9, of course That is, names can define formulas that use worksheet functions However, neither of these definitions references aThe Excel CELL function returns information about a cell in a worksheet The type of information to be returned is specified as info_type CELL can get things like address and filename, as well as detailed info about the formatting used in the cell See below for a full list of information available Applying Range Names To Formulas Microsoft Excel Cell name in excel definition