Skip to content
- Excel Won’t Let You Delete a Row? Try These FixesTo delete a worksheet row in Excel for Microsoft 365 on Windows, select its numbered heading, then choose Home > Delete >…Errors & fixes
- Excel Letter to Number: Convert Column Labels in FormulasTo convert an Excel column letter to its number, place the label in A2 and enter =COLUMN(INDIRECT(UPPER(A2)&"1")) in B2. For example, if…Formulas & functions
- Excel Let Text Spill Into the Next Cell? How It WorksYes. In Excel for Microsoft 365, text can appear to spill into the cell to its right when that neighboring cell is…Formulas & functions
- Excel Text Overflow: How It Works and How to Control ItYes. In Excel, text can visually overflow into the cell to its right when that neighboring cell is empty; the text remains…How-to basics
- Excel LET Not Working? Common Errors and How to Fix ThemExcel LET usually fails because the installed Excel version does not support it, the formula has the wrong argument structure, or a…Errors & fixes
- Excel SEQUENCE Without Gaps: Create a Continuous Number ListYes. In Microsoft 365 or Excel 2021, enter =SEQUENCE(10) in an empty cell to create the continuous list 1 through 10, with…Formulas & functions
- Excel Let Cell Overflow? How to Show Text Across CellsYes. In Excel for Microsoft 365 on Windows, text can overflow into the cells to its right when those cells are empty;…Formulas & functions
- Sequence Excel Without Duplicates: Formulas & TipsTo create a duplicate-free sequence in Excel for Microsoft 365, enter =SEQUENCE(10) in an empty cell; it spills the numbers 1 through…Formulas & functions
- Excel SEQUENCE Shortcut: Fast Ways to Create a SeriesExcel has no dedicated keyboard shortcut for the SEQUENCE function. In Microsoft 365 or Excel 2021 and later, type a formula such…Formulas & functions
- Excel SEQUENCE: Create Automatic Number SequencesYes. In Microsoft Excel for Microsoft 365, enter a SEQUENCE formula to generate a series automatically: with an empty worksheet and the…Formulas & functions
- Excel Extend Number Sequence: Fill Series and FormulasTo extend a number sequence in Excel, enter its first two values, select both cells, then drag the fill handle—the small square…Formulas & functions
- Unique in Excel: Get Values Without DuplicatesTo list each value once in Excel for Microsoft 365, enter =UNIQUE(A2:A10) in an empty cell, replacing A2:A10 with your data range.…Formulas & functions
- Excel UNIQUE Spill Error: Causes, Fixes, and ExamplesIf Excel shows #SPILL! for a UNIQUE formula, it means Excel cannot place the formula’s results in the cells it needs. Clear…Errors & fixes
- Excel Paste Unique Values: Remove Duplicates or Use a FormulaTo paste unique values in Excel, use Data > Advanced to copy distinct records to another location, or use Remove Duplicates on…Formulas & functions
- Excel Sort Shortcut: Sort Your Data Quickly and SafelyIn Excel for Microsoft 365 on Windows, press Alt, A, S, S in sequence to open the Sort dialog. For a quick…Formulas & functions
- Sort Excel by Color: Steps, Options, and TroubleshootingTo sort an Excel sheet by color in Microsoft 365 for Windows, select a cell in your data, go to Data >…Formulas & functions
- Sort Excel Numbers in Order: Steps, Formulas, and FixesTo sort numbers in Excel, select a cell in the number list and choose Data > Sort & Filter > Sort Smallest…Formulas & functions
- Sort Excel Column Without a Header Safely in ExcelTo sort an Excel column that has no header, select the data cells, then choose Data > Sort A to Z or…Formulas & functions
- Sort an Excel Column Highest to Lowest: Quick StepsTo sort numbers in Excel from highest to lowest, select a cell in the column and choose Data > Sort Largest to…Formulas & functions
- Sort Excel by Number: Steps, Options, and Common FixesTo sort numbers in Excel, select a cell in the number column, then choose Data > Sort Smallest to Largest for ascending…Formulas & functions
- Sort Excel by Date: Steps, Fixes, and Custom OrdersTo sort a worksheet by date in Excel for Microsoft 365 on Windows, select a cell in the date column, then choose…Formulas & functions
- Sort Excel Alphabetically: Rows, Columns, and ListsTo sort a list alphabetically in Excel for Microsoft 365 on Windows, select a cell in the column, then choose Data >…Formulas & functions
- Sort Excel and Keep Rows Together Without Data Mix-UpsTo sort Excel data and keep each record together, select the entire data range or click inside an Excel table, then choose…Formulas & functions
- Excel Sort Numbers Low to High: Steps, Tips, and FixesTo sort numbers from low to high in Excel for Microsoft 365 on Windows, click a cell in the number column, then…Formulas & functions
- Excel Not Working on Mac? Fixes for Common ProblemsIf Excel is not working on your Mac, first check whether the problem affects the app, one workbook, or your Microsoft 365…Errors & fixes
- Excel Not Letting You Put a 0 in Front of a Number?Excel removes a leading zero when it interprets what you type as a number. To keep the zero as part of an…How-to basics
- Excel Not Highlighting Selected Cell? Causes and FixesExcel normally marks the active cell with a colored border; when you select several cells, the rest of the selection usually gets…How-to basics
- Excel Not Keeping Formatting After Saving? Fixes That WorkExcel usually stops keeping formatting because the workbook was saved in a format that cannot store it, the formatting was applied to…How-to basics
- Excel Pivot Table Not Grouping Dates? Causes and FixesIf Excel will not group dates in a PivotTable, first check the source date column for blanks, errors, or dates stored as…Charts & pivot tables
- Excel Not Working in Windows 11? Fix Common ProblemsIf Excel is not working in Windows 11, first restart the computer, check whether Excel opens in Safe Mode, and install any…Errors & fixes