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


Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.


The Transformative Magic of Power Query M Code in Excel and Power BI

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution


Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)

December 2021

Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!


Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.


see more products »