Lookup & Reference
★ 30 · ◉ 68 · All versions
=ROW()
Returns the row number of a reference.
=ROW([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Worksheet Info & Navigation
17 functions for this use case · out of 12 defined
Lookup & Reference
★ 50 · ◉ 56 · All versions
=COLUMN()
Syntax: COLUMN([reference])
=COLUMN([reference])
Conditional Formatting & Validation
Numbering & Sample Data
Lookup & Reference
★ 40 · ◉ 56 · All versions
=ROWS()
Returns the number of rows in a reference or array.
=ROWS(array)
Numbering & Sample Data
Worksheet Info & Navigation
Information
★ 20 · ◉ 54 · Excel 2013
=ISFORMULA()
Checks whether there is a reference to a cell that contains a formula, and returns TRUE or FALSE.
=ISFORMULA(reference)
Error Handling
Conditional Formatting & Validation
Information
★ 5 · ◉ 48 · All versions
=INFO()
Returns information about the current operating environment.
=INFO(type_text)
Worksheet Info & Navigation
Information
★ 8 · ◉ 48 · All versions
=TYPE()
Returns the type of value. Use TYPE when the behavior of another function depends on the type of value in a particular cell.
=TYPE(value)
Error Handling
Worksheet Info & Navigation
Information
★ 15 · ◉ 47 · Microsoft 365
=HIDDEN()
Hidden function
Worksheet Info & Navigation
Lookup & Reference
★ 55 · ◉ 46 · All versions
=INDIRECT()
Returns the reference specified by a text string. References are immediately evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.
=INDIRECT(ref_text, [a1])
Lookup & Retrieval
Conditional Formatting & Validation
Lookup & Reference
★ 35 · ◉ 44 · All versions
=COLUMNS()
Returns the number of columns in an array or reference.
=COLUMNS(array)
Numbering & Sample Data
Worksheet Info & Navigation
Lookup & Reference
★ 45 · ◉ 41 · All versions
=HYPERLINK()
The HYPERLINK function creates a shortcut that jumps to another location in the current workbook, or opens a document stored on a network server, an intranet, or the Internet. When you click a cell that contains a HYPERLINK function, Excel jumps to the location listed, or opens the document you specified.
=HYPERLINK(link_location, [friendly_name])
Dynamic Ranges & Dashboards
Worksheet Info & Navigation
Information
★ 25 · ◉ 40 · All versions
=CELL()
The CELL function returns information about the formatting, location, or contents of a cell. For example, if you want to verify that a cell contains a numeric value instead of text before you perform a calculation on it, you can use the following formula:
=CELL(info_type, [reference])
Worksheet Info & Navigation
Information
★ 20 · ◉ 39 · Excel 2013
=SHEET()
The SHEET function returns the sheet number of the specified sheet or other reference.
=SHEET(value)
Worksheet Info & Navigation
Information
★ 6 · ◉ 38 · All versions
=ISREF()
Checks whether a value is a valid reference to a cell or range or not
=ISREF(value)
Error Handling
Worksheet Info & Navigation
Lookup & Reference
★ 25 · ◉ 37 · Excel 2013
=FORMULATEXT()
Returns a formula as a string.
=FORMULATEXT(reference)
Worksheet Info & Navigation
Information
★ 20 · ◉ 36 · Excel 2013
=SHEETS()
Returns the number of sheets in a reference.
=SHEETS(reference)
Worksheet Info & Navigation
Lookup & Reference
★ 3 · ◉ 34 · All versions
=AREAS()
Returns the number of areas in a reference. An area is a range of contiguous cells or a single cell.
=AREAS(reference)
Worksheet Info & Navigation
Lookup & Reference
★ 25 · ◉ 31 · All versions
=ADDRESS()
You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2,3) returns $C$2. As another example, ADDRESS(77,300) returns $KN$77. You can use other functions, such as the ROW and COLUMN functions, to provide the row and column number arguments for the ADDRESS function.
=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
Worksheet Info & Navigation