PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

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

group ungroup in excel
BUTTON LOCATION

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
GROUPING ROWS IN EXCEL

STEPS TO UNGROUP IN EXCEL

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

OTHER WAYS TO REACH THIS ARTICLE

  • GROUP UNGROUP ROWS IN EXCEL, FOLD ROWS AND UNFOLD ROWS

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW