Formulas > =COLUMN()

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])

Describe the lookup, get the formula Type what you want to find in plain English. The free formula generator writes the VLOOKUP, XLOOKUP, or INDEX/MATCH for you. Try the free formula generator

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

How to Record Macros

Record a macro, to Insert a column every day.

Advanced

COLUMN()

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

Let's figure out how a sheet is structured.

Beginner

COLUMN() INDEX() ROW()

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()

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

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

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

Ads keep the free stuff free. Members browse ad-free — log in or see pricing.