top of page
Services offered worldwide

or
Your partner in computer software training & application development
for over 25 years
Microsoft Excel
Use Grouping to Quickly
Show/Hide Multiple Excel Columns

Do you often hide/show the same columns in a file? Instead of constantly re-selecting the columns and choosing Hide/Unhide, why not using grouping, which is faster and more efficient? Here's how:
1. Apply grouping by selecting the consecutive columns > Data tab > Group button
2. Click the - sign to collapse or + sign to expand individual groups
3. To expand or collapse all groups, click the numbered boxes on the far left
4. To remove grouping, select the column(s) and click Ungroup
Note: Rows can also be grouped

© 2017 DJH Training & Application Solutions Inc.
bottom of page