Information about a cell: address, filename and sheet, number format, column width, protection, and more. The filename form is how a sheet can display its own name.

Syntax

=CELL(info_type, [reference])

Example

=CELL("filename",A1)

• Address

  =CELL("address",B3) → $B$3

  The absolute address.

• File and sheet name

  =CELL("filename",A1) → C:\Reports\[Q3.xlsx]Summary

  Full path, workbook, and sheet of the cell.

• Number format code

  =CELL("format",A1) → C2

  A1 is formatted as currency with two decimals.

• Sheet name: =TEXTAFTER(CELL("filename",A1),"]").
• CELL("filename") is empty until the workbook has been saved.
• Info types: address, col, color, contents, filename, format, parentheses, prefix, protect, row, type, width.

• Volatile, and the reference argument matters: without it, CELL reports the last changed cell.
• Format codes are cryptic ("C2", "D1", "P0").