Skip to content
Google Sheets

COLUMN function in Google Sheets

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

=COLUMN([cell_reference])

COLUMN syntax and parameters

One argument, zero required.

  • cell_referencerangeOptional

    [ 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.

COLUMN examples

Formulas you'll actually reuse.

  1. The column number behind a header cell, for INDEX or OFFSET math:

    =COLUMN(D2)

    Result4

  2. A 1, 2, 3… counter that survives inserting columns to its left (fill right from B):

    =COLUMN() - COLUMN($B$1) + 1

    Result1

COLUMN in Excel

Same name — your formula ports as-is.

Try COLUMN in the playground

Edit the example — nothing to install.

Preloaded with the COLUMN formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.