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!