Use “Groups” to bring the information to you. - AdvantEdge Training & Consulting

Use “Groups” to bring the information to you.

Is there information that you are constantly scrolling to find? Use “Groups” in Excel to bring the information to you.
Drag-select the columns (or rows) that you wish to group
Groups in Excel
Then click the Group command in the Outline group of the Data tab.

Groups in Excel

An expand/minimize button will appear above the columns,Groups in Excel

which will allow you to expand or minimize the columns as needed.
Groups in Excel
Now, you no longer need to scroll to important information.
Learn more tips and trips to use Excel like a pro!

For more ways to make Excel work for you, take an Excel training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top