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.
For more office techniques see our MS Office Tips.