What Number Column Is U in Excel?

How-to basics · Updated November 20, 2026

Column U is column number 21 in Excel. The count starts with A as 1, so U is the twenty-first column from the left; you can confirm it in a worksheet with the COLUMN function.

The Quick Answer: U Is Column 21

Excel assigns each column a number as well as a letter label. The labels begin A, B, C and continue through Z, then proceed to AA, AB and onward. In that sequence, U comes after T, which is column 20, and before V, which is column 22. Therefore, U corresponds to 21.

This is the same in current desktop Excel for Microsoft 365 on Windows, Excel for Mac and Excel for the web. The column’s number does not depend on the worksheet’s data, formatting, or whether the column is hidden. Hiding column U changes whether you can see it, but it does not renumber the columns on either side.

How Excel Numbers Its Columns

Excel’s column labels use a letter system that behaves like a number system with 26 symbols, except there is no zero letter. A represents 1, B represents 2, and so on through Z, which represents 26. After Z, Excel adds another letter: AA represents 27, AB represents 28, and the sequence continues.

For a single-letter column, the answer is simply its position in the alphabet. U is the twenty-first letter, so its column number is 21. For a multi-letter label, each letter contributes according to its position. For example, AA is 1 × 26 + 1, or 27. This system lets Excel label far more columns than the alphabet alone could provide.

It is useful to remember that the labels are not ordinary base-26 numbers with a zero digit. There is no column A0, and the sequence does not restart at A after Z. Instead, the next label is AA. That detail matters when converting longer column labels, but it does not complicate U: as a single letter, it maps directly to 21.

Check the Number with Excel’s COLUMN Function

The COLUMN function returns a cell reference’s column number. To check U, enter this formula in any empty cell:

With U1 as the referenced cell, enter =COLUMN(U1). Excel returns 21.

The row number in the reference does not affect the result. References to U1, U10 and U500 all point to column U, so the COLUMN function returns 21 for each. You can also select a cell in column U and use a formula that identifies the column containing the formula itself.

With the formula entered in a cell in column U, =COLUMN() returns 21. If you enter that same formula in a cell in column A, it returns 1 instead. This version is handy when you want a formula to report its own position rather than the position of a separately specified reference.

To use the function, click an empty cell, type the formula beginning with an equals sign, and press Enter. In Excel for Windows, Enter normally confirms the formula; in Excel for Mac, Enter does the same in the usual worksheet workflow. Excel for the web also supports COLUMN. No special add-in or newer-version-only feature is required.

Find Column U Without a Formula

You can locate U visually by looking at the column headings above the worksheet grid. If the sheet is scrolled horizontally, use the horizontal scrollbar at the bottom to move left or right until U appears. The Name Box, which sits to the left of the formula bar in desktop Excel, provides a quicker way to jump directly to a column.

Click the Name Box, type U:U, and press Enter. Excel selects the entire U column. To select just a cell, type a reference such as U1 instead. This approach works in Excel for Microsoft 365 on Windows and is also available in Excel for Mac; the Excel for the web interface may place worksheet controls differently, but the Name Box can also be used there.

Selecting the column is not the same as displaying its number in the worksheet. The heading remains the letter U. If you need the numeric index for a calculation, a formula such as COLUMN(U1) is the direct method. If you only need to get to the column, using the Name Box avoids counting headings by eye.

Use Column 21 in References and Calculations

Knowing that U is 21 can help when interpreting formulas, comparing column positions, or working with a process that expects numeric indexes. For instance, a function or tool may ask for a column number rather than a column letter. In that situation, 21 identifies U, provided the number is counted from the first column of the relevant range or worksheet as the instructions require.

Pay attention to what a number refers to. The worksheet-wide column number for U is 21, but U may not be the twenty-first column inside a smaller range. If a range begins at D, for example, D is its first column, E its second, and so forth. Counting within a range starts from that range’s left edge, not necessarily from worksheet column A. This distinction can prevent off-by-one errors in lookup formulas and other calculations.

Likewise, inserting or deleting columns can change which data occupies U, but it does not change the basic numbering rule. The column at the U position is still number 21. A formula that refers to a cell may adjust when columns are inserted, depending on the operation and reference, so check the formula itself if you are modifying a workbook’s structure.

Common Mix-Ups About Column U

  • Counting U as 20: T is the twentieth letter and column; U is next, so it is 21. A quick check is that A is 1 and Z is 26.

  • Confusing the column number with a row number: U21 means column U, row 21. The column’s number is 21, while the row’s number is also 21 in that particular cell reference for a different reason.

  • Assuming hidden columns change the count: They do not. If a column is hidden, Excel retains its position and its number. A visible column after a hidden one does not take over the hidden column’s number.

  • Mixing up a worksheet column and a range position: U is worksheet column 21, but it might be a different position within a selected range. Count from the range’s first column when a formula asks for a position relative to that range.

  • Expecting the number to appear in the heading: Excel normally displays letters as column headings. Use COLUMN or another suitable calculation if a numeric result is needed; the standard grid heading remains U.

Where U Falls in Excel’s Full Column Range

Column U is near the beginning of a worksheet, well before the transition to two-letter labels at AA. It is the last column before V, with 21 columns from A through U inclusive. This makes it easy to verify by counting, but a formula is less error-prone in a large or scrolled worksheet.

Modern Excel worksheets have 16,384 columns, ending at XFD. This limit applies to current Microsoft 365 editions and has been in place since Excel 2007. Earlier versions, such as Excel 2003, had a smaller grid with 256 columns ending at IV. The difference in worksheet size does not affect U’s position: it is column 21 in both older and current Excel versions.

The same column label has the same index across worksheets in a workbook. U on one sheet and U on another both mean the twenty-first worksheet column. Their contents can differ, and a formula can refer to another sheet, but the column numbering itself is consistent.

Frequently Asked Questions

What is the column number of U in Excel?
U is column number 21. Excel counts A as 1, B as 2, and continues alphabetically, making U the twenty-first column.

What formula gives the number of column U?
Use =COLUMN(U1) in a worksheet cell. It returns 21; the row number in the reference can be changed without changing the result.

Is column U the same as row 21?
No. U identifies a column, while 21 identifies a row when it appears after a column letter. In the reference U21, the cell is at the intersection of column U and row 21.

Does hiding column U change its number?
No. Hidden columns keep their original positions. U remains column 21 even when it is not visible in the worksheet grid.

What column comes after U?
V comes after U, and it is column 22. The preceding column is T, number 20.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.