Use “Groups” to bring the information to you.

Is there information that you are constantly scrolling to find? Use “Groups” to bring the information to you.
Drag-select the columns (or rows) that you wish to group
tip_01_01
Then click the Group command in the Outline group of the Data tab.
tip_01_02
An expand/minimize button will appear above the columns,
tip_01_03
which will allow you to expand or minimize the columns as needed.
tip_01_04
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 a live or online training course from AdvantEdge Training & Consulting!