Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Quickly Show/Hide Excel Columns

Courtesy of
DJH Training & Application Solutions Inc.

 

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



More Newsletter Articles

© 2017 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 25 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.