Excel 2024: Unhide One Specific Column Without Unhiding Others


February 24, 2025 - by

Excel 2024: Unhide One Specific Column Without Unhiding Others

You are presenting on a Zoom call. You've hidden columns in your spreadsheet that contain Salary, Manager, and Bonus. You need to unhide the Manager data in E but not unhide the Salary in D or the Bonus in F. Normally, you would select from column D to column G and unhide. But that would reveal the Salary and Bonus information on the call.

continue reading »

More Reading


Excel 2024: Generate All Combinations Using BASE Function

Excel 2024: Generate All Combinations Using BASE Function »

February 20, 2025 - by Bill Jelen


I occassionaly have a model where I need to test all possible combinations of several outcomes. For example, lets say that you have four different manufacturing lines and three scenarios that could happen per line.

Excel 2024: The Advanced Filter Treats Criteria as "Begins With"

Excel 2024: The Advanced Filter Treats Criteria as "Begins With" »

February 17, 2025 - by Bill Jelen


Check out this simple use of Advanced Filter. You are asking for all rows with the Product of Apple to be copied to the output range.

Excel 2024: Circle Invalid Data Automatically

Excel 2024: Circle Invalid Data Automatically »

February 10, 2025 - by Bill Jelen


You have some numbers in a worksheet. Those cells should be between 60 and 90 inclusive.

read more articles »

Featured Products


Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.


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!


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.


Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.


see more products »