PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Menu
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
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.
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
- HOW TO CONVERT TEXT TO COLUMN IN EXCEL?
- HOW TO USE CHARTS IN EXCEL?
- excel-conditonal formatting
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.