What Column Number Is H in Excel? Column Index Explained

Formulas & functions · Updated November 20, 2026

In Excel, column H is column number 8. The letters A through H count upward from 1, so H is the eighth column; you can confirm it with Excel’s COLUMN function.

The quick answer: H is column 8

Excel labels its columns with letters, but many spreadsheet tasks refer to a column by its numeric position. The count begins at the far left: A is 1, B is 2, and so on until H, which is 8. The number describes H’s position in the worksheet, not a value stored in the column or a count of the rows that contain data.

For example, cell H1 is in column 8, as is H250. Changing the row number does not change the column number. Likewise, if a worksheet is scrolled horizontally and H is not visible, it remains column 8; the screen position does not renumber it.

This answer applies to Excel for Microsoft 365 on Windows and to other current Excel editions. Column labels and their numbering work the same way in the desktop app and Excel for the web.

How Excel numbers columns

The first 26 columns use the single letters A through Z. After Z, Excel continues with two-letter labels: AA, AB, AC, and so forth. This can seem unusual if you expect the letters to restart at A, but the labels represent a continuing sequence rather than a repeating alphabet.

  • A is 1, and Z is 26.
  • AA is 27, and AZ is 52.
  • BA is 53, and ZZ is 702.
  • AAA is 703.

One way to understand the pattern is to treat the labels as a base-26 numbering system whose digits are A through Z, with A representing 1 rather than 0. That difference explains why the sequence goes from Z directly to AA: there is no zero-letter position. For a single-letter label, the count is straightforward—H is the eighth letter and therefore the eighth column.

Excel worksheets have 16,384 columns, ending at XFD. That limit is far beyond H, but it is useful when working with imported data, large models, or formulas that refer to column positions numerically.

Check the column number with COLUMN

The built-in COLUMN function returns the numeric position of a cell or range reference. To check H, enter a formula in any empty cell and Excel returns 8:

With the cell reference H1 as the argument, enter =COLUMN(H1). The result is 8, because H is the eighth worksheet column.

The row in the reference is not important for this calculation. =COLUMN(H20) also returns 8, because H20 is still in column H. If you omit the reference, COLUMN() returns the number of the column containing the formula itself. For instance, a formula entered in H5 would return 8 when written without an argument.

You can also supply a multi-cell range. COLUMN(H1:J1) returns 8, the number of the range’s first column. If you need the numbers for every column in a range, use COLUMNS to count how many columns it contains; that is a different question from asking for the starting column’s position.

Find H on the worksheet without a formula

If you only need to locate the column, look at the lettered headings above the cells. The H heading sits between G and I. Click a cell under that heading, and the Name Box—at the left end of the formula bar—shows its address, such as H1 or H12. The letter before the row number identifies the column.

You can also use the Name Box to jump directly to a cell in H. Click the box, type H1, and press Enter. Excel selects H1 and brings it into view if necessary. This works in the Windows desktop app and in Excel for the web; the Mac app has the same Name Box approach. It is handy when a sheet has many columns or when frozen panes make it difficult to tell where one section ends.

When selecting an entire column, click the H heading. Excel highlights all of column H, not just the cells currently visible on screen. If you need to select it by keyboard, click a cell in H and press Ctrl+Space on Windows. On Mac, the equivalent shortcut is Control+Space, though macOS input-source shortcuts can sometimes intercept it; clicking the heading is a reliable alternative.

Convert between a column number and a letter

Sometimes a formula, script, or data source gives you a number such as 8, while the worksheet shows letters. Excel’s ADDRESS function can turn a row and column number into a cell address. With row 1 and column 8 as the inputs, enter =ADDRESS(1,8,4). It returns H1. The final argument, 4, requests a relative address without dollar signs.

If you have a column number in B1 and want the corresponding address, the same pattern can use that cell as the column argument. With the number 8 in B1, enter =ADDRESS(1,B1,4); the result is H1. This returns an address, including a row number, rather than only the letter. It is often useful when generating references or checking a calculated column position.

Going in the other direction is easiest when the column is a real cell reference: COLUMN(H1) returns its number. If the letter H is merely text in a cell, it is not itself a cell reference, so COLUMN cannot interpret that text as a reference in the same way. For a one-off answer, H is 8; for repeated conversions from text labels, use a carefully designed formula or a lookup table rather than confusing text with a worksheet reference.

Why a column number is useful

Knowing that H is 8 helps when you compare a visible worksheet with formulas, automation, or instructions that describe positions numerically. For example, a report might say that a field is in the eighth column, while the workbook’s heading displays H. The number lets you match those descriptions quickly.

Column positions also matter in functions and tools that accept a numeric index. In a lookup formula, an index can mean the number of a column within a selected table range—not its absolute worksheet column. That distinction is important. If a table begins in column F, its first column is index 1 within that table, even though F is worksheet column 6. H would be worksheet column 8, but it would be the third column in a range starting at F.

Keep these two meanings separate:

  • Worksheet column number: H is always 8, measured from column A at the left edge.
  • Position inside a selected range: H’s index depends on where that range begins. In F:H, H is the third column.
  • Number of columns in a range: H:J contains three columns, regardless of their worksheet positions.

This distinction prevents a common mistake when building lookup formulas or interpreting imported data instructions. A number such as 3 might mean the third column of a chosen table, not worksheet column C.

Common confusions and errors

H is sometimes mistaken for a row number, especially when someone is new to spreadsheets. Excel uses letters for columns and numbers for rows, so H8 means column H and row 8. Its column number is 8, while its row number is also 8 in this particular address. In H20, the column number remains 8, but the row number is 20.

Another point of confusion is the difference between column H and the eighth column in a selected range. As noted above, the whole worksheet’s numbering starts at A. A range that starts somewhere else has its own relative positions for functions that index into that range.

Finally, hidden columns do not change the numbering. If columns C through G are hidden, the next visible column may be H, but H is still column 8. Filtering rows also does not affect column positions. H remains H whether the sheet shows every row or only a filtered subset.

Frequently Asked Questions

What number is column H in Excel?
Column H is number 8. Excel starts with A as column 1, making H the eighth column from the left.

What does =COLUMN(H1) return?
It returns 8. The function reports the worksheet column position of the reference, and the row number in H1 does not affect the result.

Is column H the same as the eighth column in a table?
Not always. H is the eighth column on the worksheet, but its position within a selected table or range depends on where that range starts. In a range F:H, H is the third column.

What column comes after H?
I comes after H, and it is column 9. The sequence continues through Z before moving to AA, which is column 27.

Does hiding columns change H’s column number?
No. H remains column 8 even when earlier columns are hidden. Hiding affects what is visible, not the worksheet’s underlying column labels or positions.

What is the last column in Excel?
In current Excel worksheets, the last column is XFD, which is column number 16,384. This is the worksheet limit, not a limit on the number of columns a particular table must use.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.