Skip to content
- Clear Excel Cell Formatting: What Changes and What StaysTo clear formatting in Excel for Microsoft 365 on Windows, select the cells, then choose Home > Clear > Clear Formats. This…How-to basics
- Upper Excel Shortcut: How to Capitalize TextExcel has no built-in keyboard shortcut that turns the selected cell’s text into uppercase. With the text maria chen in A2, enter…How-to basics
- Clean Excel Sheet: Remove Gridlines and BordersTo clean up an Excel sheet with no cell lines, open the worksheet and choose View > Show > Gridlines to turn…How-to basics
- Proper Excel Table Setup: A Clear Step-by-Step GuideTo set up an Excel table, arrange one record per row and one field per column, give every column a unique header,…How-to basics
- COUNTA Excel vs COUNT: Which Cells Do They Count in a Range?In Excel, COUNT counts numbers in a range, while COUNTA counts cells that contain something, including text, numbers, logical values, and errors.…How-to basics
- COUNTA Excel Not Working? Find the CauseIf COUNTA seems wrong, first check what is actually in the cells: the function counts any nonempty cell, including formulas that display…Errors & fixes
- COUNTA Across Multiple Excel Sheets: Formulas and TipsTo count nonempty cells in the same range across consecutive worksheets, use =COUNTA(Jan:Mar!A2:A100). This assumes the Jan, Feb, and Mar sheets each…Formulas & functions
- Count Excel Without Duplicates: Formulas That WorkTo count distinct, nonblank values in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0), replacing A2:A100 with your data range. The formula returns the…Formulas & functions
- Count Excel Without Blanks: COUNTA and Other MethodsTo count cells that are not blank in Excel, use =COUNTA(A2:A20), replacing A2:A20 with your range. COUNTA counts cells containing values, text,…How-to basics
- Count Excel Rows After a Filter: Formulas That WorkTo count rows currently visible after filtering, use SUBTOTAL on a column that has a value in every data row. With nonblank…Formulas & functions
- Count Excel Cells by Color: Practical MethodsExcel has no built-in COUNTBYCOLOR function. For a quick count in Microsoft 365 for Windows, filter the column by its fill color,…How-to basics
- Count Excel Cells by Color in Microsoft ExcelExcel has no built-in COUNTIF formula that counts cells by fill color. For a quick count, filter the range by color and…How-to basics
- Subtotal Excel Shortcut: Open the Subtotal DialogIn Excel for Microsoft 365 on Windows, press Alt+A, B in sequence to open the Subtotal dialog. It is a keyboard sequence,…How-to basics
- Excel IRR #DIV/0! Error: Why It Happens and How to FixIf Excel shows #DIV/0! beside IRR, the error is usually in one of the cash-flow formulas or cells: IRR normally reports #NUM!…Errors & fixes
- Excel XIRR With Dates: Formula, Examples, and FixesTo calculate a return from cash flows that happen on specific, uneven dates, use Excel’s XIRR function: with cash flows in B2:B4…Formulas & functions
- Text After in Excel: Formula, Examples, and FixesTo return the text after a delimiter in Excel for Microsoft 365 on Windows, use =TEXTAFTER(A2,"-"). This assumes A2 contains the text…Formulas & functions
- Excel Insert Row Shortcut: Fast Ways for Windows and MacExcel has no built-in shortcut named “IR.” If you mean insert row, select the row with Shift+Space, then press Ctrl+Shift+= on Windows…How-to basics
- Excel NPV Errors: Why Results Look Wrong and How to Fix ThemExcel NPV errors most often come from including the initial investment in the wrong place, using a discount rate that does not…Errors & fixes
- Excel NPV Calculation: Steps, Formula, and ExamplesTo calculate NPV in Excel, put the discount rate in one cell, list future cash flows in period order, and use =NPV(rate,future_cash_flows)+initial_investment.…Formulas & functions
- Excel PC Keyboard Shortcuts: Essential Keys and TipsFor Excel for Microsoft 365 on a Windows PC, start with Ctrl+C and Ctrl+V to copy and paste, Ctrl+Z to undo, Ctrl+S…How-to basics
- Excel FV for One Day: Daily Rate and Annuity ExplainedIn Excel, calculate a one-day future value with FV by using a one-day interest rate and setting the number of periods to…How-to basics
- Excel Payment Plan: Build an Installment ScheduleTo make an Excel payment plan, enter the amount borrowed, annual interest rate, and number of monthly payments, then use Excel’s PMT…How-to basics
- Rows Excel Shortcut: Insert, Delete, and Select RowsIn Excel for Microsoft 365 on Windows, select a whole row and press Ctrl+Shift+Plus to insert a new row above it. If…How-to basics
- Is Row Excel Open Source? Ownership and AlternativesIf you mean Row or Rows, the online spreadsheet often described as an Excel alternative, no: it is not an open-source version…How-to basics
- Switch Excel Workbooks: Keyboard Shortcuts and TipsIn Excel for Microsoft 365 on Windows, press Ctrl+F6 to switch to the next open workbook window, or Ctrl+Shift+F6 to switch to…How-to basics
- Switch Excel Sheet View: Normal, Page Layout, and MoreTo switch an Excel worksheet’s display mode in Microsoft 365 for Windows, select View, then choose Normal, Page Break Preview, or Page…How-to basics
- Switch Excel Number Format: Quick Steps and FixesTo switch an Excel number format, select the cell or range, then choose Home > Number Format and pick a format such…How-to basics
- Switch Excel Sheet Shortcut: Windows, Mac, and TipsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next worksheet and Ctrl+Page Up to move to…How-to basics
- Switch Excel Cell References: F4 and Reference TypesTo switch a formula reference between relative, absolute, and mixed types in Excel for Microsoft 365 on Windows, select the reference while…How-to basics
- Switch Excel Cell Format: Change Numbers, Dates, and TextTo switch an Excel cell’s format, select the cell or range, then choose a format from Home > Number Format in the…How-to basics