Excel Column K Number: What It Means and How to Find It

How-to basics · Updated November 19, 2026

In Excel, column K is column number 11. Excel counts columns from left to right, starting with A as 1, so K is the eleventh column; for a formula-based answer, use =COLUMN(K1), which returns 11.

What “column K number” means

A worksheet’s column letter and its column number are two ways of identifying the same position. Column A is number 1, B is 2, and so on until K, which is 11. The number is a position in the worksheet, not a value stored in the cells. A cell in column K can contain text, dates, numbers, formulas, or nothing at all.

The row number is a separate part of a cell address. For example, K1 means column K, row 1; K25 means column K, row 25. Both cells are in column number 11. The number 11 does not mean that the cell is on row 11, and a cell address such as K11 happens to contain both the eleventh column and the eleventh row.

This distinction is useful when a question asks for a column’s index, when a formula needs to know which column a reference belongs to, or when working with code or data tools that identify columns numerically. If someone simply asks “What number is K in Excel?”, the short answer is 11.

How Excel’s column labels work

Excel labels columns with letters rather than displaying their numbers above the grid. The labels proceed A through Z, then AA, AB, AC, and onward. This is a continuing sequence, not a switch to a different numbering system: each column still has a one-based position counted from the far left of the worksheet.

For single-letter columns, the conversion is straightforward: A is 1, B is 2, and each next letter adds one. Therefore K is the 11th letter in the alphabet and the 11th worksheet column. After Z, the labels use combinations of letters. For instance, AA is 27, because it comes immediately after column Z, which is 26.

Excel supports 16,384 columns in a worksheet, ending at XFD. That is why many column labels have more than one letter. The letter labels are designed to make references compact and readable, while the numeric positions are useful for calculations and programming. Excel’s column numbering starts at 1, not 0; this matters when comparing it with systems that use zero-based indexes.

Find the number with the COLUMN function

The COLUMN function returns the number of a referenced column. With K1 as the referenced cell, enter =COLUMN(K1) in any worksheet cell to return 11. The row chosen in the reference does not change the answer: K1 and K500 are both in column 11, so either reference gives the same result.

You can also ask Excel for the number of the column containing the formula itself. If the formula is entered in cell B2, =COLUMN() returns 2, because B is the second worksheet column. This no-argument form can be handy in a copied formula that needs to respond to its location, but it will return a different number if you move or copy the formula to another column.

For comparison, with references to K1 and A1, =COLUMN(K1)-COLUMN(A1) returns 10. That result is the number of column steps from A to K, not K’s absolute column number. The distinction matters: K is column number 11, but there are 10 spaces between the positions of A and K when counting the movement from one to the other.

When entering a formula, start with an equals sign and use a cell reference that actually belongs to the column you want to identify. The COLUMN function does not inspect a cell’s contents; it reports the position of the reference. Thus, even if K1 is blank, =COLUMN(K1) still returns 11.

Convert a column number back to a letter

Sometimes the reverse question comes up: which Excel column corresponds to number 11? The answer is K. Excel normally shows the letters at the top of the grid, so for a single column you can count from A or select a cell in that column and read its heading. In large worksheets, counting manually is error-prone, so a formula or the Name Box can be more practical.

To check a position visually, select a cell in the column and look at the column heading above it. The Name Box, to the left of the formula bar, displays the selected cell’s address, such as K7. Its first letter identifies the column. You can also type a cell reference such as K1 into the Name Box and press Enter to move directly to that location.

There is no need to count the letters in a multi-letter label as if it were a simple word. AA is not the first column after Z because A has a special meaning in this sequence; it is the 27th column. For questions involving labels beyond Z, using a reference with COLUMN is generally safer than trying to work out the position by eye.

Using column K in references and formulas

A column number is often useful behind the scenes, but ordinary worksheet formulas usually refer to cells by their letter-and-number addresses. For example, a formula that needs the value in K2 can refer to K2 directly; you do not have to replace K with 11. COLUMN is useful when a formula needs to calculate or test a position, or when a workbook uses formulas that should adjust as they are copied.

Excel references can be relative, absolute, or mixed. K1 is a relative reference: copying a formula may change it according to the move. $K$1 locks both the column and row, while $K1 locks the column only and K$1 locks the row only. These dollar signs do not change the fact that K is column 11; they control how a reference behaves when copied or filled.

For example, if a formula in another column needs to keep pointing to K1 as it is copied, use an absolute reference such as $K$1. If you want a reference to move horizontally while preserving its row, a mixed reference such as K$1 may be more appropriate. Choose the reference style based on what should stay fixed, rather than on the column’s numeric index.

Excel tables may use structured references, such as a table column’s heading, rather than worksheet letters. In that situation, a table field named “Revenue” may be clearer and more resilient to column insertions than a reference to K. The fact that the table currently appears in column K does not make 11 part of the structured reference; the table’s name and column heading identify its data.

Go to column K or select the whole column

To reach column K, click its letter at the top of the worksheet. Clicking the letter selects the entire column, while clicking an individual grid cell selects only that cell. You can also use the Name Box: type K1 and press Enter to jump to cell K1, or enter K:K to select all of column K.

On Windows, Ctrl+G opens the Go To dialog, where you can enter K1 and choose OK or press Enter. Ctrl+G is also the standard Go To shortcut in Excel for Microsoft 365. On Mac, use Control+G for Go To; depending on keyboard settings, the function-key shortcuts may differ, so the menu command or Name Box is a reliable alternative.

To select the whole column from a cell already in K, press Ctrl+Space on Windows. On Mac, the equivalent shortcut is Control+Space, though macOS keyboard settings or other applications can intercept it. Clicking the K heading avoids that shortcut conflict. Selecting an entire column can be useful for formatting or applying a column-wide operation, but use care before clearing or deleting contents because the selection includes every row in that column.

Common mistakes and useful distinctions

  • Confusing K with row 11: K identifies the 11th column. Row 11 is the horizontal line of cells labeled 11; K11 is where that row and column intersect.
  • Counting from zero: Excel’s worksheet columns are one-based. A is 1, not 0, which makes K 11.
  • Assuming the cell’s value determines the number: COLUMN(K1) returns 11 whether K1 is empty or contains data. It reports the reference’s location.
  • Mixing up distance and position: K’s position is 11, while the difference between COLUMN(K1) and COLUMN(A1) is 10.
  • Expecting the letter to stay put after an insertion: If a worksheet column is inserted before K, the cells that were in K may shift to L. Excel updates many references to track the affected cells, but the displayed letter for a location can change.

That last point is important in workbooks that rely on fixed positions. A column’s number describes where it is now in the worksheet, not an immutable identity for the data it contains. If a process depends on a particular field, a descriptive table heading or a carefully maintained named range may be more meaningful than relying only on “column 11.”

Frequently Asked Questions

What number is column K in Excel?
Column K is number 11. Excel counts from column A as 1, so K is the eleventh column from the left.

What formula gives the number of column K?
Use =COLUMN(K1). It returns 11, and the referenced row does not matter as long as the reference is in column K.

Is K the same as row 11?
No. K is a column label, and 11 is a row label when it appears beside a cell reference. K11 is the cell at the intersection of column K and row 11.

What column comes after K?
Column L comes after K and is number 12. Column J comes before K and is number 10.

How do I select all of column K?
Click the K heading above the worksheet grid, or enter K:K in the Name Box and press Enter. To go to a single cell in that column, enter a reference such as K1 instead.

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.