How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Learn Power Query in Excel: A Beginner’s GuideTo learn Power Query in Excel, start with a table or file, choose Data > From Table/Range or Data > Get Data,…
- How to Insert a Row in Excel: Steps, Shortcuts & TipsTo insert a row in Excel for Microsoft 365 on Windows, select the row number where the new row should go, then…
- Insert a Line Break in an Excel Cell on Any DeviceTo insert a line break inside an Excel cell, edit the cell, place the cursor where the next line should begin, and…
- Import CSV to Rows in Excel: Methods, Steps, and FixesTo import a CSV file into rows in Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file,…
- Import Excel Data and Export to CSV: A Practical GuideTo import a worksheet from an Excel workbook in Microsoft Excel for Microsoft 365 on Windows, select Data > Get Data >…
- Import Multiple CSV Files into Excel: Fast MethodsTo import multiple CSV files into Excel for Microsoft 365 on Windows, put the files in one folder, then choose Data >…
- How to Import CSV to Excel: Steps and Common FixesTo import a CSV into Excel for Microsoft 365 on Windows, choose Data > Get Data > From File > From Text/CSV,…
- How to Import CSV to an Existing Excel FileTo import a CSV into an existing Excel workbook in Microsoft 365 for Windows, open the workbook, choose Data > Get Data…
- Import CSV Into an Existing Excel WorksheetTo import a CSV into an existing worksheet in Excel for Microsoft 365 on Windows, choose Data > Get Data > From…
- Import CSV to Excel: Steps, Settings, and Common FixesTo import a CSV file into Microsoft Excel for Microsoft 365 on Windows, select Data > From Text/CSV, choose the file, check…
- Import a CSV into an Existing Excel WorkbookYes. In Excel for Microsoft 365 on Windows, open the workbook you want to keep, select Data > Get Data > From…
- How to Compare Two Excel Sheets and Find Every ChangeTo compare two Excel sheets, use a cell-by-cell formula when the same records occupy the same cells, or match records by a…
- How to Compare Two Excel SheetsTo compare two Excel sheets with the same layout, put this formula in a blank column beside the first sheet’s data, then…
- Excel Not Responding: How to Unfreeze It SafelyIf Excel says “Not Responding,” first stop clicking and give it a few minutes to finish the task; then try Esc and…
- How to Undo a Circular Reference in Excel Step by StepTo undo a circular reference in Excel, find the cell or cells in the loop, then edit the formula so it no…
- How to Split Just One Cell in Excel Without Changing OthersTo split just one cell’s contents in Excel, put a formula such as =TEXTSPLIT(A1,",") in an empty cell, replacing A1 with your…
- How to Split One Cell in Excel Into Two Separate PartsTo split the contents of one Excel cell into two parts, select the cell, go to Data > Text to Columns, choose…
- Corrupted Excel File: How to Repair and Recover ItTo fix a corrupted Excel file, first make a copy of it, then try Excel’s built-in Open and Repair command. If that…
- How to Split a Cell in Excel: Text, Columns, and MoreTo split the contents of a cell into two parts in Excel, select the cell or column and choose Data > Text…
- How to Run Goal Seek in Excel to Find a Target ValueTo run Goal Seek in Excel for Microsoft 365 on Windows, select the cell containing the formula you want to reach, then…
- How to Run Scenario Manager in ExcelTo run Scenario Manager in Excel, open the Data tab, choose What-If Analysis > Scenario Manager, add scenarios using your model’s input…
- How to Run Goal Seek Automatically in ExcelTo run Goal Seek automatically in Excel, create a VBA macro that calls the formula cell’s GoalSeek method, then run it from…
- How to Remove Group Rows in ExcelTo remove grouping from rows in Excel for Microsoft 365 on Windows, select a row in the group, then choose Data >…
- How to Resolve a Corrupted Excel File Without Losing DataTo resolve a corrupted Excel file, first make a copy of it, then try Excel’s built-in Open and Repair command on the…
- How to Quickly Group Rows in Excel with the Outline ToolsTo quickly group rows in Excel, select the detail rows you want to fold away, then choose Data > Outline > Group…
- How to Quit Excel When It’s Not RespondingIf Excel says “Not Responding” and will not close, first give it a short chance to finish working; if it remains frozen,…
- How to Read a Heat Map in Excel and Spot Key PatternsTo read a heat map in Excel, first identify the cells being compared and the color scale that maps values to colors;…
- How to Print a Selected Area in Excel on One Page OnlyTo print only part of a worksheet in Excel for Microsoft 365 on Windows, select the cells you want, then choose File…
- How to Put a Heat Map in Excel Using Conditional FormattingTo put a heat map in Excel, select the numeric cells you want to compare, then choose Home > Conditional Formatting >…
- How to Partially Protect an Excel SheetTo partially protect an Excel sheet, unlock the cells people should be able to edit, then protect the worksheet. In Excel for…