Group Columns Instead of Hiding Them

October 2, 2023 - by Bill Jelen

Group Columns Instead of Hiding Them

Problem: I have a report with months and quarters. My manager sometimes wants the reports printed with months hidden and other times with the months showing. It is a pain to hide/unhide the four groups of monthly columns.

Strategy: You can group the columns instead of hiding and unhiding them. Follow these steps:

continue reading »

More Reading

Hide and Unhide Data

Hide and Unhide Data »

September 29, 2023 - by Bill Jelen

I need to hide data in a worksheet, but I don’t want to delete it. Is there a way to do this besides using the previous two techniques?

Hide Values Using a Number Format

Hide Values Using a Number Format »

September 28, 2023 - by Bill Jelen

Why did you use the white font to hide those cells? Isn’t there a custom number format to hide values?

Use White Text to Hide Data

Use White Text to Hide Data »

September 27, 2023 - by Bill Jelen

My workbook needs extra columns in order to show a graph. I’d like to hide this information from the person using the workbook.

read more articles »

Featured Products

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!

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 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.

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.

see more products »