CELL
Returns information about the address, format, or content of a given cell.
Syntax
CELL(info_type; cell_ref
)
info_type: Text string that determines which information to return. E.g. "WIDTH"
|
info_type |
Description |
|
COL |
CELL() returns the column number of the referenced cell. |
|
ROW |
CELL() returns the row number of the referenced cell. |
|
SHEET |
CELL() returns the sheet number of the referenced cell. |
|
ADDRESS |
CELL() returns the absolute address of the referenced cell as text. |
|
COORD |
CELL() returns the complete cell address in Lotus (TM) notation as text. |
|
CONTENTS |
CELL() returns the contents of the upper-left most cell in a given range. |
|
TYPE |
CELL() returns text that indicates the type of cell contents in the referenced cell.
|
|
WIDTH |
CELL() returns the column width of the referenced cell. The unit is the number of zeros (0) that fit into the column in the default font and size. |
|
PREFIX |
CELL() returns text that indicates the alignment of the referenced cell.
|
|
FORMAT |
CELL() returns text that indicates the number format in the referenced cell.
|
|
COLOR |
CELL() returns 1 if the cell has number format to color negative values, and 0 otherwise. |
|
PARENTHESES |
CELL() returns 1 if the format code contains an opening bracket '(', and 0 otherwise. |
Examples
|
Formula |
Result |
|
=CELL("ADDRESS";A2) |
$A$2 |
|
=CELL("CONTENTS";A2:A4) |
500 |
|
=CELL("WIDTH";A4) |
100 |
Possible Errors
|
Errors |
Meaning |
|
#N/A! |
|
|
#NAME! |
|
|
#VALUE! |
|
|
#REF! |
|
Similar Functions
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Select a cell range
To select a cell range using mouse: 1. Click, and drag to select the cells you want. To select a cell range using keyboard: 1. Place the cursor on the desired cell and press Shift + Arrow keys. 2. To select all the filled cells in the data range from ...Customize the cell size
To customize the cell size: Select the desired range of cells. Tap under the Home menu. From the drop-down, select the desired option, and further input the values for height and width. Alternatively, you can also drag the row/column headers to ...Select multiple cell ranges
To select multiple cells/ranges: 1. Place the selection on one of the desired cell/range. 2. Press Cmd (Ctrl for Windows) and select the other desired cells/ranges. Multi-selection can be used to apply formats to discontinuous ranges simultaneously, ...Change a cell's background color
To change the cell color Select the desired cell(s). Choose Fill Color icon from the default tool bar. Click on the required color. The color is applied to the chosen cell.Hyperlink data in a cell
To insert hyperlinks: Choose the desired cell/data. Go to icon Under the Insert menu, choose Link. Choose the type of link to insert, and enter the URL/cell range/Email ID, respectively. To display a different text on the cell, enter the desired ...