Excel Tips

Try This Smoother Alternative to “Hiding” Data in Excel

When manipulating data in Excel, here’s a problem that I’m guessing many of us have experienced at one point or another: you have data that you’d like to keep for reference in an Excel sheet — but you don’t necessarily need to see all that data every time. This includes having rows/columns of additional subcategories or details, or specific formulas for reference, that you’d like to suppress for viewing purposes. 

For example, the following sheet shows extraneous data (i.e., specific states/regions) that I’d like to keep for reference but not have open at all times:

For many Excel users, the first tendency might be to “hide” the rows. Using this common method, you would simply highlight the rows you want hidden, as shown below, then right click and select the “hide” option.

In the next example, we see the end result of this action. (Note how the per-state detail from the East is hidden.)

While the “hiding” function serves its purpose in certain instances, a function that is much cleaner and useful, in my opinion, is the Group function. This feature lets viewers know that there are hidden rows/columns that can be expanded – and presents it in a much cleaner way. Additionally, viewers have a more fluid process for choosing when they’d like to see additional details.

Here’s how to do it: Simply select the rows you would like to hide -> Choose Data from the Top Nav -> Click on the Group function.

As shown in the example below, you’ll notice that there is a “+” function on row 12, alerting users that there are hidden cells that can be easily opened (and then closed again).

This is just a quick everyday tip that I hope you find useful! If you’re interested in more Excel solutions, also check out the following:

Would you like to leverage more advanced capabilities in Excel that can make an immediate impact on your organization? Keep in mind that 8020 Consulting is here to help. Contact us for more information. 

Learn more by subscribing to our blog!

Subscribe to Our Blog Today!

Categorized in:

similar articles

Learn to think and approach problems like our financial consultants.

Resources

Post-Acquisition Finance Transformation Ebook

Our free ebook offers a memorable, staged framework for navigating the complex post-acquisition finance transformation process, as well as key considerations and items for each stage.

October 21, 2021George Jacob

Financial Planning & Analysis

Tools for Building Financial Models for New Products and Services

As we scroll on our phones to pass time, we constantly get flooded with targeted ads for new products. Whether it’s for the latest iPhone or a knife so sharp that it can cut through pennies, the appetite for new products and services is a common, daily pang. The level of demand has no ceiling,… View Article

October 14, 2021Romesh Jayawardene

Financial Planning & Analysis

How to Create Better CAPEX Business Memos

At some point in time, all businesses will need to invest in new equipment, undertake a large project or take on several strategic initiatives to improve efficiency or generate additional revenues. Capital expenditures (CAPEX) are an inevitable part of growing and maintaining a competitive business. Over the years, I have been involved in various CAPEX… View Article

October 6, 2021Ebrahim Allana

See All

Back to Insights