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.