How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Excel: Protect a Sheet but Keep Slicers Usable for UsersYes. In Excel for Microsoft 365 on Windows, unlock the slicer before protecting the worksheet, then protect the sheet without granting permission…
- Excel Protect Sheet but Allow Filtering: How to Set It UpYes. In Excel for Microsoft 365 on Windows, turn on AutoFilter for the range first, then go to Review > Protect Sheet…
- Excel Protect Sheet but Allow Data Refresh?Usually, Excel cannot refresh data into locked cells on a protected worksheet: sheet protection has no general permission that says “allow refresh.”…
- Excel Protect Sheet: Can a Table Expand Automatically?Usually, no: protecting an Excel worksheet does not provide a dependable permission that lets an Excel table add rows while the sheet…
- Excel Protect Sheet but Allow Copying: What to KnowYes. In Excel for Microsoft 365 on Windows, protect the sheet and leave the relevant cells selectable; users can then copy them…
- Excel Protect Sheet: Can Users Expand Groups?Usually, no: protecting a worksheet in Excel for Microsoft 365 on Windows prevents users from expanding or collapsing grouped rows or columns…
- Excel Protect Sheet: Can You Insert Table Rows?Yes. In Excel for Microsoft 365 on Windows, you can protect a sheet and allow users to insert rows by selecting the…
- 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 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 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: 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…