How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel Protect Sheet: Can You Refresh a PivotTable?Yes. In Excel for Microsoft 365 on Windows, you can usually refresh a PivotTable while its worksheet is protected by selecting Use…
- Excel Protect Cells in a Sheet: Setup, Limits, and TipsYes. In Excel for Microsoft 365 on Windows, unlock the cells people should be able to edit, then choose Review > Protect…
- Excel Print a Certain Area: Set a Print AreaTo print only part of a worksheet in Excel for Microsoft 365 on Windows, select the cells you want, then choose Page…
- Excel Printer Not Responding? Troubleshoot the ProblemIf Excel says the printer is not responding, first check that Windows has the right printer selected and that its queue is…
- Excel Problem Solver: How to Set Up SolverYes. Excel’s Problem Solver is the Solver add-in: it finds values for selected cells that maximize, minimize, or reach a target in…
- Excel Print Area Locked? Causes, Fixes, and Workarounds ExplainedAn Excel print area usually is not permanently locked: clear or reset it from Page Layout > Print Area. If those commands…
- Excel Print Area Lines: What They Mean and How to Hide ThemExcel print area lines usually mark page breaks: dashed lines show where printed pages end, while solid lines generally indicate manually inserted…
- Excel Print Area Button: Where to Find It and How to Use ItIn Excel for Microsoft 365 on Windows, find the Print Area button on the Page Layout tab, in the Page Setup group.…
- Excel Print Area: Set It, Clear It, and Print AutomaticallyNo—Excel does not automatically expand a worksheet’s print area when you add data; a print area is a saved range that stays…
- Excel Print Area Button Greyed Out? Causes and FixesIf Excel’s Print Area button is greyed out, first exit cell-editing mode and make sure only one worksheet tab is selected; those…
- Excel Power Query: Extract a Year from Date ColumnsTo get a year from a date in Excel Power Query, select the date column and choose Add Column > Date >…
- Excel Power Query Wildcards: What Works and What Doesn’tExcel Power Query does not interpret the asterisk (*) and question mark (?) as wildcards by default. Its built-in text filters search…
- Excel Power Query Value Transformation: Types and StepsIn Excel, a Power Query value transformation changes or cleans data inside a query before it is loaded to a worksheet or…
- Excel Power Query Value Filtering ExplainedTo filter values in Excel Power Query, open the query in Power Query Editor, select the filter arrow in the column header,…
- Excel Power Query Training: Skills, Courses, and PracticeExcel Power Query training teaches you to import, clean, combine, and refresh data in Excel without repeating the same manual cleanup each…
- Excel Power Query Value Replacement: How to Use ItTo replace a value in Excel Power Query, open the query in Power Query Editor, select the relevant column, and choose Transform…
- Excel Power Query: Split a Cell Into Multiple RowsIn Excel for Microsoft 365 on Windows, use Power Query: select a cell in your source table, choose Data > From Table/Range,…
- Excel Power Query and SQL: How They Work TogetherExcel Power Query can connect to a SQL database, retrieve selected data, and reshape it before loading it into a worksheet or…
- Excel Power Query Shortcuts: Refresh, Edit, and MoreIn Excel for Microsoft 365 on Windows, press Ctrl+Alt+F5 to refresh all workbook data connections, including Power Query queries; press Alt+F5 to…
- Excel Power Query: Remove Leading ZerosIn Excel Power Query, select the column and choose Transform > Data Type > Whole Number to remove leading zeros from numeric…
- Excel Power Query: Remove Rows Based on Cell ValuesTo remove rows based on a value in Excel Power Query, open the column’s filter menu, clear the value you want to…
- Excel Power Query SharePoint Folder: Connect and RefreshYes—Excel for Microsoft 365 on Windows can use Power Query to connect to a SharePoint document library: choose Data > Get Data…
- Excel Power Query Relationships: How to Connect TablesPower Query does not create relationships between tables; it imports and transforms data. To relate tables in Excel, load them into the…
- Excel Power Query Parameters: How They WorkExcel Power Query parameters are named values that you can change to control parts of a query, such as a date filter,…
- Excel Power Query Pattern Matching: Methods and ExamplesExcel Power Query pattern matching means filtering or transforming values according to text rules such as “contains this phrase,” “starts with these…
- Excel Power Query Performance Tips That Actually HelpTo improve Excel Power Query performance, filter rows and remove unneeded columns as early as practical, let supported data sources do work…
- Excel Power Query Not Responding? Fixes That WorkIf Excel Power Query is not responding, wait briefly to see whether a large refresh is still running, then cancel it if…
- Excel Power Query Null Values: Meaning, Causes, FixesIn Excel Power Query, null means that a value is missing or unavailable; it is not the same thing as the text…
- Weekly Expense Tracker Spreadsheet: Build One in ExcelA weekly expense tracker spreadsheet is a simple Excel worksheet for recording purchases by date and category, then totaling spending over a…
- Excel Power Query Not Importing Data? Fixes to TryIf Excel Power Query is not importing data, first identify whether the failure happens while connecting to the source, transforming the preview,…