COLUMN

    Returns the column number of a specified cell, with `A=1`.

    Sample Usage

    COLUMN(A9)

    Syntax

    COLUMN([cell_reference])

    • cell_reference - [OPTIONAL - By default, the cell containing the formula ]- The cell whose column number will be returned. Column A corresponds to 1 .

      • if cell_reference is a range more than one cell wide and the formula is not used as an array formula, the position of the first column in cell_reference is returned.

    See Also

    ROWS : Returns the number of rows in a specified array or range.

    ROW : Returns the row number of a specified cell.

    COLUMNS : Returns the number of columns in a specified array or range.

    Examples

    Returns the column number of a cell reference.

    Click to open document

    Need more help?

    Try these next steps:

    Post to the help community Get answers from community members
    true
    Visit the Learning Center

    Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

    Enable Dark Mode
    Search
    Clear search
    Close search
    Google apps
    Main menu
    10530882477209291927
    true
    Search Help Center
    false
    true
    true
    true
    true
    true
    35
    false
    false
    false
    false
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: