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 excel techniques see our Excel Training Class.