How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Combine Cells in Excel on a New Line with CHAR(10)To combine values from A2 and B2 in one cell with a line break between them, enter =A2&CHAR(10)&B2 in another cell, then…
- How to Combine Cells in Excel and Keep All ValuesTo keep every entry, combine the cell contents into a result first, copy that result, and use Paste Values before removing or…
- How to Combine Cells in Excel Into One Cell EasilyTo combine the contents of Excel cells into a new cell, join them with the ampersand operator (&) or use TEXTJOIN; to…
- How to Combine Cells in Excel and Keep All Your DataWith “Ada” in A2 and “Lovelace” in B2, enter =A2&" "&B2 in C2 and fill it down to combine the contents with…
- How to Combine Cells in Excel and Keep TextTo combine the text from cells without losing anything, enter a formula such as =A2&" "&B2 in an empty cell; it joins…
- Remove Duplicates in Excel: Shortcut Keys and StepsTo remove duplicate rows in Excel for Microsoft 365 on Windows, select a cell in your data and press Alt, then A,…
- Remove Duplicates in Excel: A Practical Step-by-Step GuideTo remove duplicate rows in Excel for Microsoft 365 on Windows, select your data, choose Data > Remove Duplicates, select the columns…
- Clear Excel Shortcut: Contents, Formats, and CellsTo clear the contents of selected Excel cells on Windows, select them and press Delete. This removes values and formulas but keeps…
- 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…
- 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…
- 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…
- 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.…
- 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,…
- 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,…
- 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…
- 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,…
- 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,…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…
- 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…