• Miscellaneous Functions
  • ASSIGNEDTO Function
  • B64TOGUID Function
  • BROWSTAT Function
  • CANSIGN Function
  • CELLCALC Function
  • CELLCOL Function
  • CELLLABEL Function
  • CELLNO Function
  • CELLROW Function
  • CELLSTR Function
  • CELLTABLE Function
  • COMPLETION Function
  • COMPLTBY Function
  • CUSTPROP Function
  • CUSTPROPAT Function
  • CUSTPROPR Function
  • CVDATA Function
  • CVDATAC Function
  • CVDATAL Function
  • CVDATALNG Function
  • CVDATAQRY Function
  • CVDOCPOS Function
  • CVFORM Function
  • CVGROUP Function
  • CVIDEA Function
  • CVINFO Function
  • CVMENUST Function
  • DOCENTSCP Function
  • DOCID Function
  • DOCLIBPATH Function
  • DOCMODE Function
  • EVAL Function
  • FIELD Function
  • GETHIDE Function
  • GUIDTOB64 Function
  • HASTAG Function
  • INITIALS Function
  • INPBLANK Function
  • INPBLANKRC Function
  • ISADMIN Function
  • ISCONS Function
  • ISINGROUP Function
  • ISLOCKED Function
  • ISPLHOLDER Function
  • ISSUECOUNT Function
  • ITEMPROP Function
  • KLIEXIST Function
  • KLIPROP Function
  • KLLPROP Function
  • LEVEL Function
  • LOOKUP Function
  • Miscellaneous Functions
  • MKPATH Function
  • NUMROLES Function
  • NUMSIGNED Function
  • RDYREVIEW Function
  • REPENT Function
  • ROLECOMPLT Function
  • ROLEINDEX Function
  • ROLELABEL Function
  • SCRNX Function
  • SCRNY Function
  • SIGNOFF Function
  • SIGNOFFCHK Function
  • SIGNOFFCVR Function
  • SIGNOFFDTE Function
  • SIGNOFFNME Function
  • WHOAMI Function

CELLLABEL Function

The CELLLABEL function returns the cell label of the current cell as a string into the current cell.

Syntax

CELLLABEL(<cell number>)

If a cell number is specified, it returns the cell label of that cell as a string. This reference must be a direct cell reference. If a cell is not identified, then the function returns the cell label of the current cell.

Example 1

Enter CELLLABEL() in a cell with a cell label "Year end Calculation", returns "Year end Calculation".

Example 2

Enter CELLLABEL(ABC.D3) returns the cell label of cell ABC.D3. If that cell has no label, the function returns an empty cell. If the cell label is a function, then CELLLABEL() returns the results of that function.

Note:

Cell labels on the General tab in Edit Cell Properties do not support dependencies.

• Example: If C1 has CELLLABEL(C2) function and C2 cell label refers to C3, then any changes in C3 will not automatically recalculate in C1.
• Solution: If you are working with cells that depend on other cells to recalculate, consider using custom properties instead.

Related Topics

• Miscellaneous Functions