Microsoft Office Tutorials and References
In Depth Information
Using the CELL Function
prefix — Returns the text value corresponding to the “ label prefix ”
of the cell, as follows:
• Returns a single quotation mark (') if the cell contains left-
• Returns a double quotation mark (") if the cell contains right-
• Returns a caret (^) if the cell contains centered text.
• Returns a backslash (\) if the cell contains fill-aligned text.
• Returns an empty text ("") if the cell contains anything else.
protect — Returns 0 if the cell is not locked and 1 if the cell is
locked. Remember that, by default, all Excel cells start with their
locked property set to TRUE. The locked property is taken into ac-
count only if protection is enabled. This argument for the CELL func-
tion reports a 1 even if protection is not turned on.
type — Returns the text value corresponding to the type of data in the
cell, as follows:
• Returns b for blank if the cell is empty.
• Returns l for label if the cell contains a text constant.
• Returns v for value if the cell contains anything else.
width — Returns the column width of the cell, rounded to an integer.
Each unit of column width is equal to the width of one character in the
default font size.
Be careful with this: It is now possible to change column widths
without causing Excel to calculate. You might have to press F9 to
have the result of this formula change.
reference — Is an optional cell reference. If reference is omitted,
CELL returns the information about the last changed cell.
Refer to Figure 12.18 , which shows every CELL option for a specific cell: