How to Use COLUMN() in Google Sheets

Description

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

How To Actually Use COLUMN() in Sheets

COLUMN([cell_reference])

Try COLUMN yourself

Use the COLUMN() formula to find the column number of cell B3. Place your formula in cell D1.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Basics - Structure of a Sheet: Index() Row() and Column()

Let's figure out how a sheet is structured.

Beginner

COLUMN() INDEX() ROW()

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

COLUMN() IF() INDEX() MID() TEXT()

How to Record Macros

Record a macro, to Insert a column every day.

Advanced

COLUMN()

How Can I Compare Two Tabs for Differences?

So in this video we're going to compare two tabs and differences. Basically, someone asked actually on AppSumo, someone asked how do I compare two sheets to know what the differences are? This is the answer.

COLUMN() IF() INDEX() INDIRECT() ROW()

Transcript-matched member videos for COLUMN(). Click through to watch.

Watch more tutorials

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

Unlock these tutorials

Learn more about the COLUMN() formula:

Generate a COLUMN() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses COLUMN(). 2 free AI generations, no signup. Members get unlimited use.

Generate a COLUMN() formula