Column B is column number 2 in Excel: column A is 1, and the count starts at 1 rather than 0. If you need to use that number in a formula, Excel’s COLUMN function can return it from a cell reference.
Why Column B Is Number 2
Excel gives each worksheet column a letter label and an equivalent numeric position. The first column is A, so the next one, B, is the second column. This is a position in the worksheet, not a value that depends on what the column contains. Whether B holds names, dates, or nothing at all, its column number remains 2.
Column numbers are useful because formulas and spreadsheet features sometimes refer to a position rather than a letter. For example, a function may ask for the second column in a selected range. Knowing that B is number 2 helps you translate between the letter you see at the top of the sheet and the numeric index a formula uses.
The numbering is one-based: the first column is 1, not 0. This convention also applies to row numbers, which begin at 1. It is different from some programming languages and systems that count positions from zero, so it is a common source of confusion when people move between spreadsheets and code.
How Excel’s Column Labels Map to Numbers
Excel labels columns with letters in sequence. After Z, it starts a two-letter label at AA, then continues through AB and AC. When those labels end at AZ, Excel moves on to BA. The letters are a compact way to display column positions, and the numbering continues in the same left-to-right order.
- A = 1, B = 2, and C = 3.
- Z = 26, AA = 27, and AB = 28.
- AZ = 52, BA = 53, and XFD = 16,384, the final column in a modern Excel worksheet.
So, a longer label does not mean a separate kind of column or a new numbering system. AA is simply the 27th column, immediately after Z. Excel effectively treats the letters as a sequence of labels whose positions keep increasing; the labels do not restart the count at 1 when the second letter appears.
This matters when a question refers to a column by letter but a formula asks for a number. You can work it out by counting, but for columns far to the right, using a function is safer and quicker. For ordinary questions about column B, no conversion is needed: its position is always 2.
Find a Column Number with the COLUMN Function
In Microsoft Excel for Microsoft 365 on Windows, the COLUMN function returns the numeric position of a referenced column. To check column B, enter this in any empty worksheet cell. It assumes that B1 is an ordinary cell reference; the formula’s location does not change the answer.
=COLUMN(B1)
The result is 2. The function uses the column in the reference, not the row number, so referring to B1, B10, or B500 still identifies column B. This makes it handy when a formula needs to determine a column position without relying on a manually typed number.
If you leave out the reference, COLUMN returns the position of the cell containing the formula. For example, assuming the formula is entered in cell D1, this returns 4 because D is the fourth column:
=COLUMN()
That distinction is useful when copying formulas across a row. A formula using the current cell’s position can return a different number as it is copied into another column, while a formula that refers specifically to B1 continues to return 2. The function is available in Excel for Microsoft 365 on Windows and Mac, as well as Excel for the web; the basic result is the same across these versions.
When Column Numbers Matter in Formulas
Many Excel tasks are easier when you understand both the letter and the number. A cell reference such as B2 combines a column label and a row number: B identifies the second column, and 2 identifies the second row. In a range such as B2:D8, the selected cells extend from column B to column D and from row 2 to row 8.
Some functions use a numeric column index to choose a field within a range. For example, if a range begins at A, its first column is index 1, its second is index 2, and its third is index 3. The index is relative to the selected range, not necessarily the whole worksheet. That distinction is important: the second column of a range that starts at C is worksheet column D, not worksheet column B.
Column numbers can also help make formulas adaptable. If a formula needs to refer to a column based on where it is placed, COLUMN() can supply that position automatically. If it must always refer to a particular worksheet column, use a reference such as B1 inside the function instead. Choosing between a fixed reference and a position that changes with the formula’s location is a practical design decision.
When building or checking a formula, ask what its number represents: the absolute worksheet column, or a column’s position inside a smaller range. Mixing those meanings can produce a formula that runs without an error but returns data from the wrong field.
Column B, Cell B2, and Range References
Column B and cell B2 are related, but they do not mean the same thing. Column B is the entire vertical column and has the number 2. Cell B2 is one particular cell: it lies in column B and row 2. Similarly, B:B is a reference to all of column B, while B2:B10 refers only to a segment of that column.
The letter-and-number pattern in a cell address is consistent: letters identify the column, and the number after them identifies the row. Thus, C5 is in the third column and fifth row. A reference such as AA5 is still easy to interpret: AA is the 27th column, and 5 is the row. The column number is not the number written after the letters.
References can include dollar signs, as in $B$2, to control how a reference changes when copied. Those signs do not change the column’s position: the column is still B, or number 2. They affect reference behavior, not the worksheet’s numbering. This is another reason not to confuse a reference’s formatting with the meaning of its column label.
Common Mix-Ups and Quick Checks
A few simple checks resolve most questions about column numbers:
- Do not count A as zero. Excel starts at 1, so B is 2.
- Do not read a cell address as one number. In B7, B means column 2 and 7 means row 7.
- Do not assume a range index is a worksheet column number. In a range beginning at C, its second column is D, even though the range-relative index is 2.
- Check the reference in a formula.
COLUMN(B1)describes B, whileCOLUMN()describes the formula cell’s own column.
If the result seems unexpected, confirm that the reference points to the column you intended and that the formula is using a worksheet-wide position or a range-relative index as required. Also check whether the function has a reference argument. A missing argument is valid for COLUMN, but it asks Excel to report the formula cell’s position instead of the position of a separately specified column.
Worksheet Limits and Moving Around
In current Excel worksheets, the last available column is XFD, which is column 16,384. Column B is close to the beginning of that range, but the same increasing sequence applies all the way across. The maximum column is useful context when reading files or formulas that refer to very wide data sets; it does not change how the early columns are numbered.
You can locate column B visually by looking at the column headings above the grid. If the sheet is scrolled far to the right, use the Name Box to navigate to a cell such as B1: click the Name Box to the left of the formula bar, type the cell reference, and press Enter. Excel moves the active selection to that location. The Name Box accepts cell references, so B1 takes you to a cell in column B; it does not display the column’s numeric index.
For a quick numeric answer, the practical options are to count from A or use COLUMN with a reference in B. For a one-time question, counting is enough. If you are writing a formula that must work across changing references or ranges, using the function makes the intended relationship more explicit and reduces the chance of entering the wrong index.
Frequently Asked Questions
What number is column B in Excel?
Column B is number 2. Excel counts columns from 1, with A as the first column and B as the second.
What does COLUMN(B1) return?
It returns 2 because B is the second worksheet column. The row number in the reference does not affect the returned column number.
Is column B the same as row 2?
No. B is a column label, while 2 can be a row number. In the address B2, the cell is at the intersection of column B and row 2.
Is the second column of a range always column B?
No. It depends on where the range begins. The second column in A:C is B, but the second column in C:E is D. A range-relative position and an absolute worksheet column are different things.
What number is column AA?
Column AA is number 27. The labels continue from Z (26) to AA (27), rather than restarting the count after Z.
Related
- SMALL in Excel: Find the Nth Smallest Value with Examples
- Using RANK in Excel: Rank Numbers, Handle Ties, and More
- MIN in Excel: Find the Smallest Value in a Data Range
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create an Email Signature in Outlook on the WebTo create an email signature in Outlook on the web, open Settings (the gear icon), go to Accounts…
- MS Access vs Excel: Which Tool Fits Your Data?Microsoft Access is better for managing related records in a structured, multi-user database; Excel is better for calculations,…
- Excel: Sum a Filtered Column with SUBTOTALTo sum only the visible values in a filtered Excel column, use =SUBTOTAL(9,B2:B7), replacing B2:B7 with your data…
- How to Remove a Section Break in Word Without Losing TextTo remove a section break in Word, show formatting marks, locate the line labeled Section Break, then place…
- Excel Tips and Tricks Cheat Sheet for Microsoft 365For a fast Excel cheat sheet, turn a data range into a table with Ctrl+T, use Ctrl+Shift+L to…
- Excel MAC Address Format: Display, Clean, and ValidateIn Excel, store a MAC address as text, then display it in a consistent form such as 00:1A:2B:3C:4D:5E.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.