Excel Row Limit: Max Rows & Columns Per Sheet (2026)
Excel worksheets hold 1,048,576 rows by 16,384 columns (column XFD) — about 17.2 billion cells. Here are the real limits and what to do with bigger data.
Spreadsheets
25 posts
How to Concatenate in Excel (Combine Text from Cells, 2026)
Combine text from multiple cells in Excel: the & operator, the CONCAT and TEXTJOIN functions, adding spaces and commas, and joining a whole range with a delimiter.
How to Create a Drop-Down List in Excel (2026)
Add a drop-down list in Excel with Data Validation: build one from a typed list or a cell range, show an input message, allow blanks, and edit or remove the list.
How to Insert a Checkbox in Excel (2026)
Add checkboxes in Excel two ways: the new built-in Checkbox button in Microsoft 365, and the classic Developer-tab form control — plus how to link a checkbox to a cell and copy it down.
How to Lock Cells in Excel (2026)
Lock specific cells in Excel so they can't be edited: why locking needs sheet protection, how to unlock the cells people should still fill in, and how to protect and unprotect the sheet.
How to Merge Cells in Excel (2026)
Merge cells in Excel with Merge & Center, Merge Across, and Merge Cells — plus how to unmerge, keep all your data, and use Center Across Selection as a safer alternative.
How to Password Protect an Excel File (2026)
Password protect an Excel file with Encrypt with Password, set a separate password to open vs. modify, protect the workbook structure or a single sheet, and remove a password you no longer need.
How to Remove Blank Rows in Excel (2026)
Delete blank rows in Excel the safe way: use Go To Special to select blanks, filter them out, or sort them to the bottom — without deleting rows that only look empty.
How to Remove Duplicates in Excel (2026)
Remove duplicate rows in Excel with the Remove Duplicates tool, find them first with conditional formatting, dedupe by specific columns, or extract a unique list with the UNIQUE function.
How to Unhide Columns in Excel (2026)
Unhide columns in Excel by right-clicking, unhide column A with the Name Box, unhide all columns at once, and fix columns that won't reappear because their width is zero.
How to Use Conditional Formatting in Excel (2026)
Use conditional formatting in Excel to highlight cells by rule: highlight values, top/bottom items, data bars and color scales, formula-based rules, and how to manage or clear them.
How to Use INDEX MATCH in Excel (with Examples, 2026)
Learn INDEX MATCH in Excel: how the two functions work together, why it beats VLOOKUP, looking left, a two-way lookup with two MATCH functions, and error fixes.
How to Use SUMIF in Excel (with Examples, 2026)
Learn SUMIF in Excel: the syntax, text and number criteria, comparison operators, wildcards, summing a different column, and SUMIFS for multiple conditions.
How to Use the IF Function in Excel (with Examples, 2026)
Learn the IF function in Excel: the syntax, text and number tests, nested IFs, the IFS function, combining IF with AND and OR, and how to fix common errors.
How to Use VLOOKUP in Excel (with Examples, 2026)
Learn VLOOKUP in Excel step by step: the syntax, exact vs. approximate match, looking up data from another sheet, anchoring the range, and how to fix #N/A and #REF errors.
How to Use XLOOKUP in Excel (with Examples, 2026)
Learn XLOOKUP in Excel: the syntax, exact and approximate match, looking left, returning multiple columns, the built-in if_not_found argument, and how it beats VLOOKUP.
How to Wrap Text in Excel (2026)
Wrap text in Excel so long entries show on multiple lines inside one cell: the Wrap Text button, manual line breaks with Alt+Enter, adjusting row height, and common fixes.
How to Create a Drop-Down List in Google Sheets (2026)
Add a drop-down list in Google Sheets using data validation: build one from a typed list or a range, allow multiple selections, color-code options, and edit or remove it.
How to Create a Pivot Table in Google Sheets (2026)
Build a pivot table in Google Sheets to summarize and group data: add rows, columns, and values, change how values are summarized, add filters, and refresh when data changes.
How to Freeze Rows in Google Sheets (and Columns, 2026)
Freeze the header row in Google Sheets so it stays visible while you scroll — plus freezing multiple rows, freezing columns, doing it on mobile, and unfreezing.
How to Remove Duplicates in Google Sheets (4 Methods, 2026)
Remove duplicate rows in Google Sheets with the built-in Data cleanup tool, the UNIQUE function, conditional formatting to find them first, or COUNTIF to flag them.
How to Use Conditional Formatting in Google Sheets (2026)
Highlight cells automatically in Google Sheets with conditional formatting: single-color rules, color scales, formatting based on another cell, and custom formula rules.
How to Use the IF Function in Google Sheets (with Examples, 2026)
Master the IF function in Google Sheets: the syntax, nested IFs, IFS for multiple conditions, and combining IF with AND, OR, and ISBLANK — with copy-paste examples.
How to Use the QUERY Function in Google Sheets (with Examples, 2026)
Use the QUERY function in Google Sheets to filter, sort, and summarize data with SQL-like syntax: SELECT, WHERE, ORDER BY, GROUP BY, LABEL, and pulling from another sheet.
How to Use VLOOKUP in Google Sheets (with Examples, 2026)
Learn VLOOKUP in Google Sheets step by step: the syntax, exact vs. approximate match, looking up data from another sheet, and how to fix #N/A and #REF errors.