Skip to content
- Excel Column Selection: Select One or More ColumnsIn Excel for Microsoft 365 on Windows, click a column letter to select that entire column, or click a cell in the…How-to basics
- Excel Column Number Reference: Letters and NumbersIn Excel, columns have both letter references and number positions: A is 1, Z is 26, AA is 27, and the final…How-to basics
- Excel Column Names Changed to Numbers? How to Fix ItIf Excel’s column headings show numbers instead of letters, the usual cause is R1C1 reference style. In Excel for Microsoft 365 on…Errors & fixes
- Excel Column Name to Number: Formula and ExamplesIf cell A1 contains an Excel column name, enter =COLUMN(INDIRECT(A1&"1")) to return its number: A returns 1, Z returns 26, AA returns…Formulas & functions
- Excel Column Number to Letter: Formula and ExamplesTo convert an Excel column number to its letter name, enter a number such as 28 in A2 and put =SUBSTITUTE(ADDRESS(1,A2,4),"1","") in…Formulas & functions
- Excel Column Limit: What XFD Means and How It WorksMicrosoft Excel allows 16,384 columns in a worksheet, running from column A to column XFD. This limit applies to modern Excel, including…How-to basics
- Excel Column Letter to Number List and Conversion GuideExcel columns use letters, but each letter or letter combination has a number: A is 1, Z is 26, AA is 27,…How-to basics
- Excel Column Is a Number Instead of a Letter? Fix ItIf Excel shows column headings as 1, 2, 3 instead of A, B, C, turn off R1C1 reference style. In Excel for…Errors & fixes
- Excel Column Height: AutoFit Rows and Fix Wrapped TextExcel does not have a separate column-height setting: columns have width, while rows have height. To make text fit vertically, select the…Errors & fixes
- Excel Column Numbers: What A, Z, AA and XFD Mean in ExcelExcel columns have numerical positions even though their headings use letters: A is column 1, Z is 26, AA is 27, and…How-to basics
- Excel Column Headings on Each Page: How to Repeat ThemTo print a worksheet’s header row on every page in Excel for Microsoft 365 on Windows, choose Page Layout > Print Titles,…How-to basics
- Excel Column Filter Not Working? Fixes That HelpIf an Excel column filter is not working, select a cell in the dataset and choose Data > Filter (or press Ctrl+Shift+L…Errors & fixes
- Excel Column Filter Not Showing All Values? Fix ItIf an Excel column filter is not showing all values, first clear filters on the other columns and confirm that the filter…Errors & fixes
- Excel Column Filter Dropdown: How to Add, Use, and Fix ItIn Excel for Microsoft 365 on Windows, select a cell in your data and choose Data > Filter to add a dropdown…Errors & fixes
- Excel Column Drop-Down List: Create and Manage OneTo add a drop-down list to an Excel column, select the cells that should contain it, then choose Data > Data Validation…How-to basics
- Excel Column Difference Between Two Columns ExplainedIn Excel, “column difference” can mean comparing values in two columns, finding items that appear in one list but not the other,…How-to basics
- Excel Column Comparison: Formulas, Methods, and TipsTo compare two Excel columns, use a row-by-row equality test when corresponding cells should match, or check whether each value in one…Formulas & functions
- Excel Column Compare: Find Differences With FormulasTo compare values on the same rows in Excel, put this formula in C2 when the two columns are A and B,…Formulas & functions
- Excel Column Alphabetical Order: A to XFD ExplainedExcel’s worksheet columns are labeled A through Z, then AA through AZ, BA through BZ, and onward to the final column, XFD.…How-to basics
- Excel Column Letter to Number: Formula, Examples, and TipsTo convert an Excel column letter to its number, put the letter in A1 and enter =COLUMN(INDIRECT(UPPER(A1)&"1")) in another cell. For example,…Formulas & functions
- Excel Yes or No Drop-Down: Create and Customize ItYes. In Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation > Data Validation, set Allow to…How-to basics
- Excel Cell Word Wrap: How to Turn It On and Fix RowsTo wrap text in Excel, select the cell or cells, then choose Home > Wrap Text. Excel for Microsoft 365 on Windows…Errors & fixes
- Excel Cell Won’t Change Color? Find the FixIf an Excel cell won’t change color, check whether Conditional Formatting is controlling its fill; a rule can override the color you…Errors & fixes
- Excel Cell Value From List: Find or Select a MatchTo return a value from a list when you know a matching item, use XLOOKUP; with product IDs in A2:A5, names in…Formulas & functions
- Excel: Make Cells Turn Red or Green AutomaticallyYes. In Excel for Microsoft 365 on Windows, select the cells, then choose Home > Conditional Formatting and create rules that apply…How-to basics
- Excel Cell Text Limit: Characters, Display, and FixesIn Microsoft Excel for Microsoft 365 on Windows, a cell can contain up to 32,767 characters, including spaces and punctuation. Excel may…How-to basics
- Excel Cell Size in CM: What the Measurements MeanExcel does not give every cell a single size in centimeters. A cell’s width comes from its column-width setting, measured mainly in…How-to basics
- Excel Cell Selection: Ranges, Lists, and ShortcutsTo select a list of cells in Excel, press Ctrl+G, type the cell references separated by commas—for example, A1,A3:A5,C2—and press Enter. You…How-to basics
- Excel Cell Reference Types: Relative, Absolute, and MixedExcel has three main cell reference types: relative (A1), absolute ($A$1), and mixed ($A1 or A$1). They determine whether a formula’s column,…How-to basics
- Excel Cell Pull-Down Lists: Create, Edit, and Fix ThemTo create an Excel cell pull-down list in Microsoft 365 for Windows, select the cell, choose Data > Data Validation, set Allow…Errors & fixes