How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Row Limit Per Sheet: Maximum Rows ExplainedMicrosoft Excel supports a maximum of 1,048,576 rows per worksheet, from row 1 through row 1,048,576. That limit applies to modern desktop…
- Excel Row and Column AutoFit: Steps, Limits, and FixesTo auto-adjust Excel row or column size, select the relevant rows or columns, then choose Home > Cells > Format > AutoFit…
- Excel Row Count Limit: Maximum Rows and What It MeansIn current versions of Microsoft Excel, a worksheet can contain up to 1,048,576 rows. That is the limit for one sheet, not…
- Excel Row at Top of Each Page: Repeat Header Rows in PrintTo print the same row at the top of every page in Excel, go to Page Layout > Print Titles, open the…
- Excel Row Always on Top? Keep It Visible While ScrollingYes—if you mean keeping a heading row visible while you scroll, choose View > Freeze Panes > Freeze Top Row in Excel…
- Excel Column Width and Row Height: Are They Equal?No. Excel column width and row height use different units, so entering the same number for each does not make a square…
- Excel Columns Keep Collapsing? Causes and FixesIf Excel columns keep collapsing, they are usually hidden or grouped into an outline—not deleted. On Windows, select the affected column headers,…
- Excel Column Sorting Drop-Down: How to Use ItIn Excel for Microsoft 365 on Windows, click the arrow in a column header and choose Sort A to Z or Sort…
- Excel Column to Comma-Separated List: Easy MethodsIf your values are in A2:A20, enter =TEXTJOIN(", ",TRUE,A2:A20) in an empty cell to turn the column into one comma-separated list. For…
- 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…
- 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…
- Excel Column Size: Width, Pixels, and How to Change ItIn Excel, column size is set as a width measured in character-based units, not as a fixed number of pixels. A common…
- 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…
- 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,…
- 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,…
- 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…
- 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,…
- 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…
- 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.…
- 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…
- 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…
- 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…
- 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…
- 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,…
- 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…
- Excel Cell Margins: Add Top and Bottom SpaceExcel does not have a separate top or bottom cell-margin setting. To create space inside a cell, adjust its row height and…
- Excel Cell Height Limit: Maximum Row Height ExplainedIn Excel for Microsoft 365 on Windows, the maximum row height—and therefore the height of every cell in that row—is 409 points,…
- Excel Cell Highlight Color: How to Change ItTo change a cell’s highlight color in Excel for Microsoft 365 on Windows, select the cell or range, then choose Home >…
- Excel Cell Character Limit: What 32,767 Really MeansAn Excel cell can contain up to 32,767 characters. That is the maximum stored in one cell in current Microsoft Excel, including…
- Excel Cell Bullet Points: Add and Format Lists in CellsYes. In Excel for Microsoft 365 on Windows, edit a cell and press Alt+0149 on the numeric keypad to insert a bullet…