![]() ![]() Then a click on Group button will display a Group window, where it asks whether you want to group the data in Rows or Columns. You are just selecting a few adjacent cells to the group. If you are not selecting the data to be grouped either from the column header or row header. If you click on the minus button the grouped columns will collapse and now, you will now observe a plus button in column header using which you can again expand the collapsed column. You can observe a scale above the column header which has a minus button. Step 2: In the Data tab under the Outline group, click on the Group drop-down button. Select the columns that you want to group from the column header. Like in the image below, I can group the sales done on Monday, Wednesday & Friday as it will easy for me to study the sales done by each staff in the entire week. Step 1: First of all, analyse the data that you want to group. We will also discuss the method of auto outline and nested grouping of the data. ![]() In this section, we will discuss the method of grouping the data in columns or rows. It helps you to create a more compact version of your large scale data. Grouping also helps you to organize your data in a better way. In addition to this, the Group in Excel can group data at different levels. Earlier we have seen several methods to deal with a large scale of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |