How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- QuickBooks Excel and CSV Toolkit Cost: What to KnowThe QuickBooks Import Excel and CSV Toolkit from Intuit is a free utility when available for a supported QuickBooks Desktop edition; it…
- Why Excel Files Get Corrupted and How to Prevent ItAn Excel file usually gets corrupted when its data cannot be written or read correctly—for example, after a crash, interrupted save, storage…
- Quadrant Scatter Plot in Excel: Create and Format OneTo create a quadrant scatter plot in Excel, insert an XY scatter chart, then add one vertical and one horizontal helper series…
- QuickBooks Data Export to Excel: Steps and OptionsTo export QuickBooks data to Excel, open the report or list you need and choose its Excel export option; in QuickBooks Online,…
- QuickBooks Excel and CSV Imports: What You Can Bring InYes. QuickBooks can import Excel and CSV files, but the right method depends on whether you use QuickBooks Online or QuickBooks Desktop…
- Python Excel: Remove Duplicates with pandas or openpyxlTo remove duplicate rows from an Excel file with Python, use pandas: read the worksheet with read_excel(), call drop_duplicates(), and write the…
- How to Protect and Unprotect Sheets in ExcelIn Excel for Microsoft 365 on Windows, protect a worksheet by opening it and choosing Review > Protect Sheet, selecting the actions…
- Protect Columns in Excel: Lock Cells and Set PermissionsTo protect columns in Excel for Microsoft 365 on Windows, unlock the cells people may edit, leave the cells in the columns…
- Protect Part of an Excel Sheet: Steps and LimitsTo protect part of an Excel sheet, unlock the cells people may edit, leave the cells you want protected locked, then choose…
- Print a Specific Area in Excel: Steps, Scaling, and FixesTo print a specific area in Excel for Microsoft 365 on Windows, select the cells, then choose Page Layout > Print Area…
- Excel Print Area: Set, Change, and Clear ItAn Excel print area is the cell range—or ranges—you choose to send to the printer or a PDF. In Excel for Microsoft…
- Power Query to Compare Two Excel Sheets Step by StepTo compare two Excel sheets with Power Query in Microsoft 365 for Windows, turn each data range into a table, load both…
- Power BI File Corrupted? Check Its Excel DataA Power BI file can show corrupted-looking Excel data, but importing an Excel workbook into Power BI normally does not change or…
- Power Automate Excel: Group Rows Automatically in a FlowYes—but not with a built-in Power Automate action called “Group rows.” To create Excel’s collapsible row outlines automatically, use an Office Script…
- Power Automate Excel Consolidation: A Practical GuideYes. Power Automate can consolidate data from multiple Excel workbooks by reading rows from a named table in each source file and…
- Postcode Heat Map in Excel: Data, Setup and LimitsYes—Excel for Microsoft 365 can make a postcode heat map using a Filled Map chart: put postcode areas and their values in…
- Polynomial Solver in Excel: Methods, Limits, and TipsExcel has no built-in command that symbolically solves every polynomial, but you can find real roots with the Solver add-in: calculate the…
- PKSolver in Excel: What It Does and How to Use It SafelyYes. PKSolver is an Excel add-in for pharmacokinetic and pharmacodynamic data analysis; it is separate from Microsoft Excel’s built-in Solver tool. It…
- Password Protect an Excel Sheet as Read-OnlyYes. In Excel for Microsoft 365 on Windows, use File > Save As > Browse, open Tools > General Options in the…
- Password Protect an Excel Sheet from Editing SafelyTo password protect an Excel sheet from editing in Microsoft 365 for Windows, open the worksheet and select Review > Protect Sheet.…
- Password Protect an Excel Sheet From Viewing: What WorksTo stop someone from viewing an Excel file, encrypt the workbook with a password to open it: in Excel for Microsoft 365…
- One-Row Data Table in Excel: How to Set Up and Use ItA one-row data table in Excel is a What-If Analysis tool that tests several possible values for one input and displays the…
- One-Column Data Table in Excel: How to Create OneIn Excel for Microsoft 365 on Windows, create a one-column data table by placing trial values in a vertical list, putting a…
- One-Dimensional Data Table in Excel: How It WorksA one-dimensional data table in Excel shows how changing one input affects one or more formula results. In Excel for Microsoft 365…
- Numerical Solver in Excel: How It Works and When to Use ItYes—Excel includes Solver, an add-in that can numerically find values for selected cells to maximize, minimize, or reach a target in a…
- No Remove Duplicates Option in Excel? Find ItExcel for Microsoft 365 on Windows has a Remove Duplicates command on the Data tab: select a cell in your list, then…
- No Hyperlink in Excel? Remove or Prevent LinksTo remove a hyperlink in Excel for Microsoft 365 on Windows, right-click the linked cell and choose Remove Hyperlink. To stop Excel…
- Excel File Corrupted? How to Check, Repair, and RecoverYour Excel file may be corrupted if Excel cannot open it or reports damaged content, but an error message alone does not…
- Named Range in Excel: Definition, Uses, and ExamplesA named range in Excel is a descriptive name assigned to a cell, a group of cells, or another value that you…
- Multiple Goal Seek in Excel: What Works and What Doesn’tExcel’s Goal Seek can solve for one changing cell to make one formula reach one target per run; it cannot set several…