Column O is column number 15 in Excel. You can confirm it with =COLUMN(O1), which returns 15; the number is the same in Excel for Microsoft 365 on Windows, Mac, and the web.
Why O Is Column 15
Excel labels worksheet columns with letters, but many formulas and data operations use numbers to identify them. Counting from the first column gives A as 1, B as 2, and so on. O is the fifteenth letter of the English alphabet, so it labels the fifteenth worksheet column.
The count is based on the column’s position in the worksheet, not on whether the column contains data. A blank column O is still column 15, and hiding columns does not change their numbers. If columns are inserted or deleted to the left of O, the letter associated with a particular data field can change because its position in the grid has changed.
It can help to distinguish a column label from a cell address. O is a column label; O1 is the cell at the intersection of column O and row 1. O:O refers to the entire column, while O1:O20 refers to a range of cells within it.
How Excel Numbers Columns
Excel’s column labels continue after Z by combining letters. The first 26 columns run from A through Z. The next is AA, column 27, followed by AB, column 28. This is a base-26-style labeling system, though Excel’s labels do not use a zero symbol between letters. For example, AZ is 52 and BA is 53.
Here are useful landmarks for checking a column position:
- A is column 1, and O is column 15.
- Z is column 26.
- AA is column 27, and AZ is column 52.
- BA is column 53.
- XFD is column 16,384, the last column in a modern Excel worksheet.
The same numbering applies on every worksheet in a workbook. Each sheet has its own grid, but column O is still the fifteenth column on each one. A worksheet’s active cell, selected range, or current view does not change the numbering.
Find O’s Number with the COLUMN Function
The COLUMN function returns the number of a column reference. With O1 as the reference, it returns 15. For a direct check, enter the formula in any empty cell:
With O1 as the reference, enter =COLUMN(O1). The result is 15.
You do not have to put the formula in column O. The reference inside the parentheses determines the result. For example, if a worksheet has values in A1 and O1, entering =COLUMN(O1) in a separate cell still returns 15. The formula identifies O1’s position on the worksheet; it does not count columns from the formula cell.
If you enter =COLUMN() without a reference, Excel returns the column number of the cell containing the formula. Thus, if the formula is entered in O2, it returns 15; if entered in P2, it returns 16. This version can be useful in formulas copied across columns, but the result depends on where the formula is placed.
A reference can also be written as an entire column. With column O as the reference, =COLUMN(O:O) returns 15. For a quick one-time check, however, a cell reference such as O1 is often easier to read and maintain.
Use Column 15 in Formulas and References
Knowing that O is 15 matters when a formula asks for a numeric column index rather than a letter. For instance, the INDEX function can use 15 to select a value from the fifteenth column of a specified range. The important detail is that INDEX counts columns within the range you give it—not necessarily from column A of the worksheet.
Suppose a table spans C1:Q10. Within that range, worksheet column O is the thirteenth column, not the fifteenth: C is the first column of the selected range, so O is counted as position 13 from C. By contrast, if the range begins at A, O is its fifteenth column. This distinction is a common source of off-by-a-few-column errors in lookup formulas.
Column numbers also appear in functions such as COLUMN and in tools that build cell references. A number such as 15 can represent O when it means a worksheet-wide column position. Before using it as a range-relative position, check where the range starts. If a formula is intended to follow a field when columns are rearranged, using a direct cell reference or a clearly defined table column may be more understandable than hard-coding a number.
Cell references can be relative or absolute. O1 is a relative reference, while $O$1 fixes both the column and row when a formula is copied. The dollar signs do not change the column number: $O$1 is still in column 15. They only affect how the reference behaves when copied or filled.
Navigate to Column O
If the sheet is wide, you do not need to scroll across every column to reach O. In Excel for Microsoft 365 on Windows, click the Name Box to the left of the formula bar, type O1, and press Enter. Excel selects cell O1 and brings it into view. The Name Box is also available in Excel for Mac and Excel for the web, though the surrounding interface can look different.
To select the entire column, type O:O in the Name Box and press Enter. You can also click the O column heading at the top of the worksheet. Selecting a whole column is useful for applying formatting or checking the column, but use care when applying changes: the selection includes every row in that column, including blank cells.
Another Windows option is the Go To dialog. Press Ctrl+G or F5, enter O1, and confirm to move to that cell. On Mac or in Excel for the web, using the Name Box is a straightforward alternative if the keyboard shortcut or key mapping differs on your setup. Typing O15 instead of O1 takes you to column O, row 15; it does not mean column number 15 by itself.
Common Confusions About Column O
The letter O can look like the digit zero, especially in a narrow font or a screenshot. Excel’s column heading is the letter O, not the number 0. There is no worksheet column numbered zero: Excel’s first column is A, numbered 1. When entering a cell reference, O1 means column O, row 1; it is different from a reference containing a zero, such as A10.
Another misconception is that O becomes a different number if earlier columns are hidden. Hiding a column changes what is visible, not the underlying position. If A through N are hidden, O may appear beside another visible column, but it remains worksheet column 15. Likewise, filtered rows do not affect column numbering.
Also note that column number and row number describe different directions. In O7, O identifies the column and 7 identifies the row. The cell address does not mean column 7 or row 15. Reading the address in this order helps when checking references in formulas or identifying a field in a large sheet.
Column Numbers Across Excel Versions
Column O has been the fifteenth column in Excel’s lettered worksheet grid, and the answer does not depend on a special Microsoft 365 feature. Excel versions with the modern worksheet size support 16,384 columns, ending at XFD. Older Excel versions had fewer available rows and columns, so the last-column limit depended on the version, but O is far earlier than those limits.
In current Excel for Microsoft 365, the worksheet grid can extend to XFD, but a particular workbook may contain only a small amount of used data. That does not make O the fifteenth column only when it has content; the position is built into the sheet. Other spreadsheet applications also use lettered columns, but their maximum worksheet sizes and feature sets can differ. The answer here refers to Excel’s worksheet column labels.
Frequently Asked Questions
What number is column O in Excel?
O is column 15. The count starts with A as 1 and proceeds one column at a time.
What does =COLUMN(O1) return?
It returns 15 because O1 is in the fifteenth worksheet column. The formula can be entered in any cell.
Is O the same as zero in an Excel reference?
No. O is a letter used as a column label, while 0 is the digit zero. Excel’s first column is A, not column zero.
What is column O in a range that starts at C?
Within a range beginning at C, O is the thirteenth column of that range. Across the whole worksheet, O remains column 15.
How do I go directly to column O?
Type O1 in the Name Box and press Enter to select a cell in column O. To select all of O, enter O:O in the Name Box or click its column heading.
Does hiding columns change O’s number?
No. Hidden columns still count in the worksheet grid, so O remains column 15 even when some columns before it are hidden.
Related
- Vendor Comparison Sheet Excel Template: What to Include
- Vendor Comparison Template Excel: Free Scorecard Guide
- Vendor Contact List Excel Template: Fields and Setup
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Corrupted Excel File Repair: What to Try FirstFor a corrupted Excel file, first make a copy of the file, then try Excel’s built-in Open and…
- How to Add a Timestamp in Google Sheets AutomaticallyTo add a fixed timestamp in Google Sheets, select a cell and press Ctrl+Alt+Shift+; on Windows or ChromeOS;…
- Google Sheets Date Difference: Formulas and ExamplesIn Google Sheets, subtract the earlier date from the later date to get the difference in days: if…
- Excel Data Validation: Steps, Rules, and Common FixesTo add data validation in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data…
- How to Clear Cache in Outlook 365 on Windows, Mac, and WebTo clear the Outlook 365 cache, first choose the version you use: classic Outlook for Windows can rebuild…
- Create a Box Plot in Excel: Steps and InterpretationTo create a box plot in Excel for Microsoft 365 on Windows, put each group of numeric observations…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.