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.
Learn more tips and trips to use Excel like a pro!
For more excel techniques see our Excel Training Class.