HOW TO GROUP AND UNGROUP IN EXCEL?

INTRODUCTION

“GROUP AND  UNGROUP” helps to manager the rows and columns easily. Group combines all the rows into one entity which can be collapsed or expanded as per need. Both the functions are pretty simple to use but useful to handle large data.

BUTTON LOCATION FOR GROUP AND UNGROUP IN EXCEL

The option or button location for the GROUP AND UNGROUP options can be found under the DATA TAB in OUTLINE SECTION.

BUTTON LOCATION FOR GROUP AND UNGROUP OPTIONS

BUTTON LOCATION FOR GROUP AND UNGROUP OPTIONS IN EXCEL 2007

STEPS TO GROUP IN EXCEL

  • STEPS:
  • SELECT THE ROWS WHICH ARE TO BE GROUPED.
  • CLICK GROUP.
  • A “+” SIGN APPEARS ON THE ROW NUMBER WHICH CAN BE CLICKED TO FOLD OR UNFOLD THE ROWS.
GROUPING ROWS IN EXCEL

STEPS TO UNGROUP IN EXCEL

  • STEPS:
  • Simply select all the grouped elements and click UNGROUP.

EXAMPLE SHOWING GROUPING AND UNGROUPING

A simple example showing the process of grouping and ungrouping in excel.

EXAMPLE SHOWING THE STEPS TO GROUP AND UNGROUP IN EXCEL