Use “Groups” to bring the information to you – Excel

When using Excel, 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.
groups excel
An expand/minimize button will appear above the columns,
groups excel
which will allow you to expand or minimize the columns as needed.
groups excel
Now, you no longer need to scroll to important information.

Power up your Excel skills with a training course from AETC!