How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- How to Delete Blank Rows in Excel in One Go SafelyTo delete completely blank rows in Excel at once, add a helper column that marks rows with no data, filter that column…
- How to Delete Blank Rows in an Excel Column SafelyTo delete entire rows where a chosen Excel column is blank, select the data range, choose Home > Find & Select >…
- Delete Blank Rows in Excel All at OnceTo delete fully blank rows in Excel all at once, add a temporary helper column, mark rows with no content, filter for…
- How to Delete Blank Rows at the End of an Excel SheetTo delete blank rows beneath your data in Excel for Microsoft 365 on Windows, find the last row you need, select the…
- How to Insert a Row in Excel Without a Mouse: ShortcutsTo insert a row in Excel without a mouse, move to a cell in the row that should shift down, press Shift+Space…
- How to Insert a Row in Excel Above a Selected CellTo insert a worksheet row above a cell in Excel for Microsoft 365 on Windows, select any cell in the row where…
- Insert Row in Excel: Keyboard Shortcut for WindowsTo insert a worksheet row in Excel for Microsoft 365 on Windows, select the row where the new one should go with…
- How to Insert a Row in Excel After Any Specific RowTo insert a blank row after a specific row in Excel, select the row number directly below it, then choose Home >…
- Insert a Blank Row in Excel After Every Row of DataTo insert a blank row after every data row in Excel, add a temporary helper column, number your records 1, 3, 5…
- How to Unhide Rows in Excel With a Keyboard ShortcutTo unhide rows in Excel for Microsoft 365 on Windows, select the row headers immediately above and below the hidden rows, then…
- How to Hide Columns in Excel Without Deleting DataTo hide columns in Excel for Microsoft 365 on Windows, select the column letters, right-click the selection, and choose Hide. The data…
- How to Hide Columns in Excel on iPad Without Deleting DataTo hide a column in Excel on iPad, tap its letter at the top of the worksheet to select it, then choose…
- Lock Cell References in Excel With Dollar Signs EasilyTo lock a cell reference in an Excel formula, add a dollar sign before the column letter, the row number, or both—for…
- How to Lock Cells in Excel While Scrolling a WorksheetTo keep headings or columns visible while you scroll in Excel for Microsoft 365 on Windows, select the cell just below and…
- How to Lock Cells in Excel for MacTo lock cells in Excel for Mac, select the cells, open Format Cells and check Locked on the Protection tab, then choose…
- Wrap Text in Excel: Keyboard Shortcut and Quick StepsIn Excel for Microsoft 365 on Windows, select the cell or cells and press Alt, then H, then W to turn Wrap…
- How to Freeze Panes in Excel Without Freezing the First RowTo freeze rows or columns other than the first row in Excel for Microsoft 365 on Windows, select the cell immediately below…
- How to Freeze Panes in Excel: Keep Rows and Columns VisibleTo keep headings or identifying columns visible while you scroll in Excel for Microsoft 365 on Windows, select the cell immediately below…
- Freeze Multiple Columns in Excel: A Step-by-Step GuideTo freeze multiple columns in Excel for Microsoft 365 on Windows, select the cell immediately to the right of the last column…
- Freeze Multiple Rows in Excel: Step-by-Step GuideTo freeze multiple rows in Excel, select the cell in column A directly below the last row you want to keep visible,…
- How to Merge Cells in Excel Without Losing Your DataTo merge cells in Excel without losing their contents, first combine the values you need into the top-left cell or a separate…
- Merge Cells in Excel Without Merging: Center AcrossTo make a heading look centered across several Excel columns without combining the cells, select the range, open Format Cells, and choose…
- How to Merge Cells in Excel and Keep All TextTo merge cells in Excel and keep all their text, first join the contents with a formula such as =TEXTJOIN(" ",TRUE,A2:C2), paste…
- Merge Cells in Excel: Keyboard Shortcuts and StepsIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, C—one key sequence at a time—to merge them…
- Merge 2 Cells in Excel: A Step-by-Step GuideTo merge two cells in Excel, select the adjacent cells, then choose Home > Merge & Center ▼ > Merge Cells. This…
- Merge Cells in Excel and Keep All DataTo merge cells in Excel without losing their contents, first combine the contents into one cell, then merge the range. Excel’s Merge…
- Combine Cells in Excel: Shortcut and Safe StepsTo merge selected cells in Excel for Microsoft 365 on Windows, select the range and press Alt, H, M, M one key…
- Combine Cells in Excel With a Dash Between Text ValuesTo combine two cells in Excel with a dash between them, place the values in A2 and B2, then enter =A2&"-"&B2 in…
- Combine Cells in Excel With Dates Without Losing FormatTo combine a date with text without displaying its underlying serial number, use a formula that applies TEXT to the date first.…
- Combine Cells in Excel for Mailing AddressesTo combine address parts into one cell, put the street in A2, city in B2, state in C2, and ZIP code in…