How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Solver: Find a Target Sum with Changing CellsTo make a set of numbers add up to a target in Excel, create a total formula, use Solver to set that…
- How to Set Up Solver in ExcelTo set up Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in from File > Options > Add-ins, then…
- Solver in Excel: How to Enable and Set It UpTo put Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in under File > Options > Add-ins, then select…
- Install Solver in Excel: A Step-by-Step Setup GuideTo install Solver in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose Excel Add-ins beside Manage, select…
- How to Open Solver in Excel and Enable the Solver Add-inIn Excel for Microsoft 365 on Windows, open Solver by going to File > Options > Add-ins, choosing Excel Add-ins beside Manage,…
- Find Solver Parameters in Excel and Understand Each OneTo find Solver parameters in Excel for Microsoft 365 on Windows, open the worksheet you want to optimize, select Data > Solver,…
- How to Find a Z-Score Using Excel Solver Step by StepTo find a z-score from a cumulative probability, put a starting z value in one cell, calculate its standard normal cumulative probability…
- Excel Goal Seek Shortcut: Open It, Set a Target, SolveIn Excel for Microsoft 365 on Windows, open Goal Seek by pressing Alt, then A, W, and G in sequence. You can…
- How to Enable Solver in Excel on Windows and MacTo enable Solver in Excel for Microsoft 365 on Windows, choose File > Options > Add-ins, select Excel Add-ins beside Manage, click…
- Flash Fill in Excel: Keyboard Shortcut and How to Use ItTo use Flash Fill in Excel for Microsoft 365 on Windows, type one example of the result you want in the column…
- Autofill in Excel From Another Cell: A Practical GuideTo autofill from another cell in Excel, select the cell you want to copy, then drag its fill handle over the destination…
- Excel Data Validation Source: How to Find ItTo find a dropdown list’s source in Excel for Microsoft 365 on Windows, select a cell with the dropdown, open Data >…
- How to Autofill in Excel From the Cell Directly AboveTo fill cells from the one above in Excel, select the source cell and the cells below it, then press Ctrl+D on…
- Excel Data Validation Drop-Down: Create and Edit ListsTo create a drop-down list in Excel for Microsoft 365 on Windows, select the cell or cells, choose Data > Data Validation…
- Excel Data Validation With Color: Step-by-Step GuideTo add color to Excel data validation, create a drop-down list with Data > Data Validation, then use Home > Conditional Formatting…
- Excel Data Validation: Copy Rules Quickly and SafelyTo copy only data validation in Excel for Microsoft 365 on Windows, copy a cell that has the rule, select the destination…
- Add to a Data Validation List in Excel: Step-by-StepTo add an option to an Excel drop-down list, select a cell that uses the list, open Data > Data Validation, and…
- Find and Replace in Excel: Select Data FirstTo find and replace text in only part of an Excel worksheet, select the cells or range first, press Ctrl+H, enter the…
- Compare Two Columns of Names in Excel: Find MatchesTo check whether names in one list appear anywhere in another, put the first list in A2:A6 and the second in B2:B6,…
- Excel Power Query: Import Multiple CSV FilesTo import and combine multiple CSV files in Excel for Microsoft 365 on Windows, put the files in one folder, then select…
- Can You Import Excel and CSV Files Into QuickBooks?Yes. QuickBooks can import Excel and CSV files for certain kinds of data, but the accepted format depends on whether you use…
- Compare Two Columns in Excel for DifferencesTo compare two Excel columns row by row, put a comparison formula in a third column and fill it down. With the…
- How to Convert Text to Numbers in an Excel ColumnTo convert text-formatted numbers in an Excel column, select the cells, click the warning icon that appears beside the selection, and choose…
- Convert Text to Number in Excel Faster: Quick MethodsTo convert text-stored numbers quickly in Excel for Microsoft 365 on Windows, select the cells and use the warning icon’s Convert to…
- Excel Date Format Shortcut: Change Dates in SecondsTo change selected cells to Excel’s standard date display in Microsoft Excel for Microsoft 365 on Windows, select the cells and press…
- How to Change Date Format in Excel on Windows 11To change how dates appear in Excel on Windows 11, select the date cells, press Ctrl+1, choose a format on the Number…
- Convert Text to Number in Excel Cells: Quick FixesTo convert text to numbers in Excel, select the affected cells and click the warning icon, then choose Convert to Number. If…
- How to Add a Heading to Every Printed Page in ExcelTo repeat a heading row on every printed page in Excel for Microsoft 365 on Windows, open the worksheet and choose Page…
- Change Date Format in Excel Cells: A Step-by-Step GuideTo change how a date appears in an Excel cell, select the cell or range, press Ctrl+1 on Windows, choose a format…
- Add a Header in Excel on the First Page OnlyTo add a header only to the first printed page in Excel for Microsoft 365 on Windows, open the worksheet in Page…