November 21, 2025
I’ve hidden columns D:F and need to unhide only column D. Is there a way to only unhide that column? I could unhide all three columns and then re-hide the two that I don’t need to be visible, but this seems crazy.
Yes – there is a cool trick to solve this. Although column D is hidden, you can use the Go To dialog to select a cell in the hidden column D before running the Unhide Column command. Follow these steps:
Excel: How Can I Hide Some Columns? »
November 19, 2025
I used a couple of columns that are needed for the calculation but do not need to be in the printed report. Although my data goes from A:H, I do not need to print columns D, E, or F. How can I print the worksheet but not those columns?
Excel: How Do I Undo Conditional Formatting? »
November 17, 2025
I know you can drag the fill handle to extend a series. What’s up with the little box that pops up near the end of the series?
Excel: How Do I Make a Cell Show an Abnormality in a Spreadsheet? »
November 13, 2025
Say that I am logging some quality scores. Any time that a score is below 90, I want to highlight the cell in red.
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
January 2025
Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you’ve never created a pivot table before, this book will help you leverage their flexibility and analytical power and includes exploration of new array functions and Copilot capabilities in analysis creation.
Power BI for the Excel Data Analyst
July 2022
A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.
Microsoft 365 Excel: The Only App That Matters
June 2022
Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!
Programming Excel with Office Scripts
July 2025
Visual Basic for Applications isn’t the only game in town anymore. With Programming Excel with Office Scripts: Straight to the Point, Eduardo N. Sanchez cuts through the noise and gives you a fast-paced, example-packed guide to automating Excel using Office Scripts and TypeScript.