How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- How to Print Just a Highlighted Area in ExcelTo print only part of an Excel worksheet, select the cells you want, then choose Page Layout > Print Area > Set…
- How to Merge Cells in Excel Without Losing Data SafelyTo merge cells in Excel for Microsoft 365 on Windows, select the adjacent cells, then choose Home > Merge & Center. Excel…
- Excel Table: Make a Plain Data-Only Table From Your DataTo make a plain table from data in Excel for Microsoft 365 on Windows, put the data in a continuous range with…
- Import Excel CSV Files in Python: A Step-by-Step GuideTo import a CSV file saved from Excel into Python, install pandas, then use import pandas as pd and df = pd.read_csv('sales.csv').…
- Lock a Named Range in Excel Without Locking Other CellsTo lock a named range in Excel, select the cells it refers to, make sure their Locked setting is on, and protect…
- How to Group and Expand Rows in Excel: A Practical GuideTo group rows in Excel for Microsoft 365 on Windows, select the row numbers you want to fold away, then choose Data…
- How to Wrap Text in Excel Columns: Quick Steps and TipsTo wrap text in an Excel column, select the column or cells, then choose Home > Wrap Text. Excel displays long cell…
- How to Get Back a Corrupted Excel File Without Losing DataTo get back a corrupted Excel file, first make a copy of it, then try Excel for Microsoft 365 on Windows: choose…
- Compare Two Excel Sheets Easily in Microsoft ExcelTo compare two Excel sheets quickly, put their values in the same row and column order, then use a helper column with…
- How to Consolidate Quantities in Excel by Item NamesTo combine repeated quantities for each item, put each item name once in a summary list and use SUMIF to add its…
- How to Designate a Print Area in Excel for Clean PagesTo designate a print area in Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page…
- How to Consolidate Numbers in Excel by Sheet or LabelTo consolidate numbers in Excel, select a blank destination cell, then choose Data > Consolidate. Set the function to Sum, add each…
- Compare Numbers in Two Excel Sheets: A Practical GuideTo compare values in the same rows of two sheets, put this formula in a spare column: with the values in B2…
- Recover a Corrupted Excel File From Your PCTo collect and recover a corrupted Excel file from your PC, find the workbook in File Explorer, make a separate copy, then…
- How to Add Rows to an Existing Group in ExcelTo add rows to an existing Excel outline group, insert them between rows that are already grouped, then expand or collapse the…
- Add a Jigsaw Sudoku Solver to ExcelTo add Solver to Excel for Microsoft 365 on Windows, go to File > Options > Add-ins, choose Excel Add-ins beside Manage,…
- Add Quadrants to an Excel Scatter Plot: Step-by-StepTo add quadrants to an Excel scatter plot, create one vertical and one horizontal helper-data series at your chosen thresholds, then format…
- How Excel Files Become Corrupted: Causes and RisksAn Excel file becomes corrupted when its stored data or internal workbook structure is damaged or incomplete, so Excel cannot read it…
- How to Activate Flash Fill in Excel: Shortcuts and FixesTo activate Flash Fill in Excel for Microsoft 365 on Windows, enter an example of the result in the column beside your…
- How to Insert a Row in an Excel Spreadsheet: Quick StepsTo insert a row in Excel for Microsoft 365 on Windows, click the worksheet row number where the new row should go,…
- How to Make a Heat Map in Excel Using Color ScalesTo make a heat map in Excel for Microsoft 365 on Windows, select the numeric cells, then choose Home > Conditional Formatting…
- How to Create a Heat Map in ExcelTo create a heat map in Excel for Microsoft 365 on Windows, select the numeric cells, then choose Home > Conditional Formatting…
- How to Group Rows in Excel for Clearer WorksheetsTo group rows in Excel, select the row numbers you want to collapse, then choose Data > Outline > Group; if Excel…
- Excel Group Rows Shortcut: The Key and How It WorksIn Excel for Microsoft 365 on Windows, select the rows you want to group and press Alt+Shift+Right Arrow. Excel adds an outline…
- How to Compare Two Excel Sheets for Matches in ExcelTo check whether an ID in one sheet appears anywhere in another, put this formula in the first sheet beside the ID:…
- Excel Print Area Shortcut: Set and Clear It QuicklyIn Excel for Microsoft 365 on Windows, select the cells you want to print, then press Alt+P, S, P in sequence to…
- Excel Insert Row Shortcut: The Fastest Way to Add RowsIn Excel for Microsoft 365 on Windows, select the row where you want a new row, then press Ctrl+Shift+Plus (+)—usually Ctrl+Shift+= on…
- Heat Map Scatter Plot in Excel: How to Build OneTo make a heat map scatter plot in Excel, plot your X and Y measurements as an XY scatter chart, then divide…
- Hide and Password-Protect Columns in ExcelTo hide a column in Excel for Microsoft 365 on Windows, select its letter, then choose Home > Format > Hide &…
- Hide Column C in Excel: Steps to Hide and Unhide ItTo hide column C in Excel for Microsoft 365 on Windows, right-click the C column heading and choose Hide. To show it…