CELL
The CELL function retrieves information about the formatting, location, or contents of a cell. It helps analyze specific cell characteristics within a worksheet.

Example explanation
Cells D2 through D5 demonstrate the use of the CELL function to retrieve information about various attributes of the A2 cell, such as their address and contents.
Syntax 🔗
=CELL(info_type
, reference
)
info_type | A text value specifying the type of cell information to be retrieved. |
reference | The reference to the cell for which the information is to be retrieved. |
About CELL 🔗
The CELL function in Excel helps you gather information about individual cells in your worksheet. By using this function, you can obtain details such as a cell's formatting, location, and attributes related to its content. This can assist you in analyzing and managing your data more effectively. The CELL function is a useful tool for gaining insights into the characteristics and properties of cells in your workbooks.
Examples 🔗
To get the address of cell A1, use the formula: =CELL("address", A1). This returns the cell's absolute reference as text.
To find the format code of cell B3, use the formula: =CELL("format", B3). This shows the format code applied to the cell's content.
Notes 🔗
Use the CELL function to extract specific information about a cell, such as its address, contents, or formatting. This function helps you understand the characteristics of a cell, allowing for better data manipulation and analysis in your Excel worksheet.
Questions 🔗
The CELL function can retrieve various types of information, including the cell's address, contents, formatting, and other specific attributes based on the specified info_type
argument.
Yes, the CELL function can retrieve formatting information of a cell by specifying "format" as the info_type
argument. This provides insights into the specific formatting applied to the cell's contents.
Absolutely! The CELL function serves as a valuable asset for analyzing and manipulating data in Excel by providing detailed insights into the characteristics and properties of individual cells. This facilitates informed decision-making and streamlined data manipulation workflows.