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
Then click the Group command in the Outline group of the Data tab.
An expand/minimize button will appear above the columns,
which will allow you to expand or minimize the columns as needed.
Now, you no longer need to scroll to important information.
For more office techniques see our MS Office Tips.