In Excel, V is column number 22. Column letters run from A=1 through Z=26, so V is the 22nd column from the left.
Why V maps to 22
Excel labels worksheet columns with letters, but many spreadsheet operations identify a column by its position as a number. The labels are sequential: A is 1, B is 2, and each step to the right adds one. Counting forward gives V as 22. This is the same in Microsoft Excel for Microsoft 365 on Windows, Excel for Mac, and Excel for the web.
The alphabet-based labels continue after Z. The next column is AA, which is 27, followed by AB, which is 28. These are not two separate column numbers or labels that restart at 1; they use a base-26-like lettering scheme so Excel can name columns beyond the first 26. For the one-letter label V, no multi-letter conversion is needed: its position is simply 22.
Column numbers are useful because formulas and programming interfaces often refer to positions rather than visible labels. A person may describe a field as being in column V, while a formula or data operation needs the number 22. Keeping both forms in mind helps when interpreting formulas, importing data, or troubleshooting a reference.
Check the number with the COLUMN function
The quickest formula check is the COLUMN function. With a reference to cell V1, enter =COLUMN(V1) in any cell. Excel returns 22. The row number in the reference does not affect the result: V1, V25, and V500 are all in the same worksheet column.
The reference does not have to contain data. V1 can be blank; COLUMN reads the location of the reference, not the value stored there. This makes it a handy way to verify a column index without changing or filling the worksheet. You can also select the reference while writing the formula, rather than typing its address manually.
With no reference argument, COLUMN reports the position of the cell containing the formula. For example, if you enter the formula in V2, it returns 22. If you enter it in C2, it returns 3. That distinction matters: =COLUMN() does not always mean column V; its answer depends on where the formula itself is placed.
COLUMN returns a number, not the letter label. It is useful when a calculation needs a positional index, such as selecting a field from a range. If you need to display the letter V to a reader, the worksheet header already supplies that label; COLUMN is intended to provide the numeric position.
Convert a column label stored as text
Sometimes a column label is in a cell as text rather than being a reference in a formula. For a simple example, with the text V in A1, enter =COLUMN(INDIRECT(A1&"1")) in another cell. It builds the address V1 from the text and asks COLUMN for that reference’s position, returning 22.
This approach also works for valid multi-letter labels such as AA, provided the text in A1 is a real Excel column label. INDIRECT turns text that looks like a reference into a reference. It is volatile, meaning Excel recalculates it more frequently than many ordinary formulas, so using it repeatedly across a very large workbook may be less efficient. It can also produce an error if the text is misspelled, contains unwanted spaces, or names a column outside the worksheet.
For a one-off lookup, direct reference is usually simpler: use V1 in COLUMN rather than building a reference from text. The text-based method is mainly useful when a label comes from a dropdown, imported file, or another cell and the calculation needs to respond when that label changes. If labels come from outside the workbook, validate them before relying on the result.
Find column V on the worksheet
If you want to go to the actual column rather than calculate its number, use the Name Box. It is the small box to the left of the formula bar that normally shows the active cell address. Click it, type V1, and press Enter. Excel selects cell V1, and the view moves to that location if necessary. This works in the desktop versions and is also available in Excel for the web.
You can also scroll horizontally until the V header appears. On a wide worksheet, that may take time, especially if the sheet is already far to the right. Selecting a cell address through the Name Box is more direct. The column header is the letter at the top of the grid; clicking the V header selects the entire column, while choosing V1 selects just one cell.
To inspect a cell’s location, select it and look at the Name Box. If it shows V7, the selected cell is in column V and row 7. The letter identifies the column, while the number identifies the row. This visual check is helpful when a formula references a cell and you want to confirm that the address points to the intended field.
Where column numbers are useful
For everyday editing, Excel’s letters are usually more readable than numbers. Column numbers become more useful in formulas or processes that work with a range by position. For example, if a range starts in A and a calculation needs its 22nd field, that position corresponds to V when the range begins at A. But if the range starts somewhere else, its 22nd field may be a different worksheet column.
That distinction prevents a common mistake: a worksheet column number is an absolute position on the sheet, while an index within a selected range is a position relative to that range. If a range begins at C, its first field is C even though C is worksheet column 3. Thus, the number 22 means column V when counting from the worksheet’s left edge, but it means the 22nd item when counting within a range only if the range’s starting point is taken into account.
Column position can also help with audits and data checks. Suppose an exported report is expected to place a status field in V. Checking that the header is in V and that its column number is 22 can reveal a shifted or inserted field. The number alone does not verify that the right data is present, though: it confirms position, not the meaning or contents of the column. Check the header and sample values as well.
Common mix-ups and mistakes
- Confusing V with the 22nd letter in a different sequence: Excel starts column A at 1, so V is 22. It is not necessary to count from zero.
- Mixing up the row and column: In V10, V is the column and 10 is the row. COLUMN(V10) returns 22; the row number does not change it.
- Assuming the answer changes with the cell contents: COLUMN reports location. Replacing a value in V1 does not change that cell’s column number.
- Using the number as a range-relative position by mistake: Worksheet column V is 22, but the 22nd item in a range that starts later than A will not necessarily be V.
- Expecting a letter from COLUMN: COLUMN returns a number. The visible header or a text-conversion method is needed if the desired output is a label.
Another frequent source of confusion is a hidden or frozen column. Hiding columns does not renumber the remaining columns. Even if some columns are not visible, V remains worksheet column number 22. Likewise, frozen panes affect what stays visible while scrolling, not the underlying addresses or numbering.
Excel limits and version details
In current Excel worksheets, the last column is XFD, which is column number 16,384. V is therefore very near the beginning of the available columns. This limit applies to modern Excel worksheet grids, including Microsoft 365. The COLUMN function and the A-to-V numbering are longstanding features, so no newer dynamic-array function or special subscription is needed to find this answer.
Excel for Mac and Excel for the web use the same column labels and return the same result from COLUMN. The worksheet grid may look slightly different depending on the platform, but V remains number 22. The Name Box is a practical navigation method across these versions; if the interface is arranged differently, look beside the formula bar for the box that displays the active cell address.
Frequently Asked Questions
What number is column V in Excel?
Column V is number 22. Counting starts with A as 1, so V is the 22nd column.
Does COLUMN(V1) return 22 even if V1 is blank?
Yes. COLUMN uses the address of the reference, not the cell’s contents. A blank V1 is still in column 22.
What is the difference between column V and the 22nd column in a range?
Column V is the worksheet’s 22nd column, counting from A. The 22nd position in a range is counted from that range’s first cell, so it may point to a different worksheet column.
Does hiding columns change V’s number?
No. Hiding columns only changes what is displayed. V remains column number 22 whether other columns are visible or hidden.
How do I jump straight to column V?
Type V1 into the Name Box and press Enter. Excel selects that cell and moves the worksheet view to it if needed.
Related
- Can You Insert an Image Into an Excel Cell?
- Can You Delete Duplicates in Excel? Methods and Tips
- Delete Multiple Tabs in Excel at Once: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting Color Based on Value in ExcelIn Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting and select…
- Excel Ctrl Shortcuts: Essential Keys ExplainedIn Excel for Microsoft 365 on Windows, Ctrl shortcuts are key combinations that speed up common tasks: press…
- How to Double Space a Paper in Word on Windows and MacTo double space a paper in Microsoft Word, select the text you want to change, then choose Home…
- Excel Not Responding and Not in Task ManagerIf Excel says Not Responding but you cannot find it in Task Manager, first check the Processes and…
- How to Add Page Numbers to Each Page in WordTo number every page in Microsoft Word, open the document and select Insert > Page Number, choose a…
- Dependent Dropdowns in Google Sheets: Setup and FixesTo make a dependent dropdown in Google Sheets, create a named range for each group of choices, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.