![\"Grouping](\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2021\/04\/group.png\")
<\/a><\/p>\n2: Choose the cells.<\/p>\n
3: Choose groups from the menu.<\/p>\n
4: A box appears with the option of rows and columns.<\/p>\n
5: Choose the ones you wanted to group either rows or columns.<\/p>\n 6: Click ok.<\/p>\n Note: When we click on rows, then it hides the whole row and we will also get 2 states for each group on the side of the spreadsheet.<\/p>\n Have a look at the sample to understand it more clearly.<\/p>\n We have chosen the cell A4, A5 for grouping row-wise.<\/p>\n The 1 and 2 numbers apart from the serial number are the state numbers. Each state number performs different actions.<\/p>\n If you click on 1, it hides the grouped data.<\/p>\n Hope you noticed the serial number after 3 is 6.<\/p>\n If you click on 2, it unhides the grouped data.<\/p>\n Hope you saw the dots near the serial number 4 and 5. These dots indicate that they are grouped together and once when we click 2, the data is unhidden.<\/p>\n When you click on the \u2018-\u2019 symbol it hides the data and changes the symbol to +. It indicates that we can unhide the data by clicking on the + symbol.<\/p>\n <\/p>\n Here also, we can see that row 4 and row 5 are not visible as hiding takes part.<\/span><\/p>\n By clicking on the + symbol, the data is unhidden.<\/p>\n Now, let\u2019s have a look at how the group works if we choose the column option in the box.<\/p>\n It hides the whole column if we choose the \u2018columns\u2019 group, the dots are now seen above the columns.<\/p>\n Observe that state number 1, 2 are now visible above the columns. Once we press the state number 1, the D column follows the A column hiding the B and C columns.<\/p>\n Once we press state number 2, the grouped columns will appear back in the spreadsheet.<\/p>\n Look at the – and + symbols. It also works as such in the rows grouping but this time it hides the columns. Let’s look at the sample:<\/p>\n When we press on the – symbol, the symbol changes back to the + symbol. It indicates that the columns are hidden are ready to revert back anytime.<\/p>\n Now, when we press on the + symbol, the B and C columns are visible.<\/p>\n Another interesting fact is that we can also group inside a group. Let’s have a look at the sample to form a group inside a group.<\/p>\n The \u2018.\u2019 symbol in column c is corresponding to state 3 which means it is being grouped inside a group.<\/p>\n Now, let’s have a look at how it works. When we press the state 1, the column B and C are temporarily hidden.<\/p>\n When we press state 2, the c column is alone hidden.<\/p>\n Observe that the D column follows column B hiding column C.<\/p>\n When we press state 3, the c column is again visible.<\/p>\n This is how grouping inside a group works. Now, let\u2019s have a look at the grouping of rows and columns together.<\/p>\n In this case, when we press the – symbol on both sides, the rows, as well as the columns, will be hidden.<\/p>\n Observe that the – symbol is being changed to +.<\/p>\n After the number 3, the number 6 has come, depicting that rows 4 and 5 are hidden. Also, after the A column, the D column is being followed depicting the temporary hiding of B and C columns.<\/p>\n Ungroup is a feature that helps in ungrouping the cells which were once grouped.<\/p>\n To apply ungroup, follow the steps:<\/p>\n 1: Click on the DATA tab menu.<\/p>\n 2: Choose the ungroup option from the ribbon.<\/p>\n 3: Choose either its row or column.<\/p>\n 4: Click on it.<\/p>\n Let’s understand looking at a sample:<\/p>\n Hope, you noticed that the state numbers and the dot above the B and C columns are being removed. This means that the grouped cells are ungrouped using the ungroup option.<\/p>\n Subtotal is a feature that helps in deriving the subtotal for your data values in the spreadsheet. To apply subtotal to your dataset, follow the steps:<\/p>\n 1: Click on the cells in the spreadsheet.<\/p>\n 2: Click on the data tab menu.<\/p>\n 3: Choose subtotal from the ribbon.<\/p>\n A box appears asking for- at each change in, use function, add subtotal to.<\/p>\n There are another 3 checkboxes. Check the boxes once you feel like it\u2019s necessary and those options are- replace current subtotals, page break between groups, and summary below data.<\/p>\n Replace current subtotals:<\/b> It keeps replacing the subtotals.<\/span><\/p>\n Page break between groups:<\/b> This provides a page break between groups and is viewed in PDF only.<\/span><\/p>\n Summary below data:<\/b> This provides you the summary below the groups.<\/span><\/p>\n Let’s understand this feature with a sample:<\/span><\/p>\n From the sample, we can understand that for each change in the tutorial, the function is being applied. Let’s see a sample:<\/p>\n Once we click on the \u2018-\u2019 symbol beside row numbers 3 and 7, it’s converted to \u2018+\u2019 and only the subtotals are visible in the spreadsheet. The datasets for those particular groups are not visible in the spreadsheet since they are being hidden.<\/p>\n The rows corresponding to the \u2018-\u2019 symbol contain the details of the particular group and also the subtotals.<\/p>\n The state numbers are 3 in this case.<\/p>\n If we press 1, only the grand total appears.<\/p>\n When we press 2, the subtotals alone appear.<\/p>\n If we press 3, the dataset appears along with the subtotal.<\/p>\n This is how subtotal works on the spreadsheet.<\/p>\n Now, let’s get into the features of filters in MS-Excel.<\/p>\n Filtering in Excel helps to hide the data records temporarily. It also helps in focusing on certain records which meet the condition criteria by hiding the other data in the spreadsheet.<\/p>\n To apply filters on the dataset, follow the steps:<\/p>\n 1: Place the cursor on a cell.<\/p>\n 2: Go to the DATA tab.<\/p>\n 3: Apply filter from the menu.<\/p>\n Once you click the filter, the header in the dataset appears with a dropdown menu.<\/p>\n Once you click on the dropdown, it shows a box with different functions.<\/p>\n The main functions that are performed by filters are sorting and number filters.<\/p>\n The values below search are the data values provided in the spreadsheet. We can also make use of the search tab to search for particular data.<\/p>\n If you wanted to view some of the data, then uncheck the box beside \u2018select all\u2019 and choose whichever data you wanted to view.<\/p>\n Let’s now, look at how the sorting works.<\/p>\n When you click on it, the data appears from the smallest value to the largest value.<\/p>\n From the above sample, we can see that the marks are being arranged in ascending order and the names are also shifted according to the replacement of the marks.<\/p>\n From the above sample, we can see that the marks are being arranged in descending order and the names are also shifted according to the replacement of the marks.<\/p>\n Data filters can be applied on different data types such as:<\/span><\/p>\n Let\u2019s look at a sample:<\/span><\/p>\n Filters can perform their task even on the text data types.<\/p>\n In the above sample, we are going to sort the names from A to Z. Let\u2019s now apply a filter and try it out.<\/p>\n Hope, you all noticed that the names are being arranged from A to Z using filters.<\/p>\n Filters perform their task even on the numeric data types.<\/p>\n In this sample, we are going to arrange the marks in ascending order using filters.<\/p>\n Hope, you observed that the marks column is being arranged in ascending order using the filter options.<\/p>\n The filters perform the task on the date column also. Let’s look at a sample to understand it more clearly.<\/p>\n In this sample, we are going to arrange it from the oldest to newest in the date column.<\/p>\n From the above sample, we can see that the dates are arranged from the oldest to the newest using filters.<\/p>\n The values which are being colored will appear when we filter by the color differentiation.<\/p>\n In the sample, the students whose marks are very low are being colored green and using filters by colors, the excel provides that particular data alone.<\/p>\n Notice that the other cells are temporarily hidden. After row number 1, it is being followed by row number 9 and 10.<\/p>\n If you have applied a filter to the header, then the clear filter activates. This means that if you wanted to remove the filter from the header, then you can just click on it. Once you click, the filter will be removed by which all the unhidden data records will be visible back again.<\/p>\n Hope, you can notice that the clear filter from marks is being activated, once you click on it.<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nUngrouping in Excel<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\nSubtotal in Excel<\/h3>\n
<\/a><\/p>\n\n
<\/a><\/p>\n
\nThe \u2018-\u2019 symbol helps in hiding the details of the dataset. It provides only the subtotals of that particular group and once the \u2018-\u2019 symbol is being clicked, it\u2019s converted to \u2018+\u2019.<\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nFilters in Excel<\/h3>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\nSort Smallest to Largest in Excel<\/h3>\n
<\/a><\/p>\nSort Largest to Smallest in Excel<\/h3>\n
<\/a><\/p>\nTypes of Data Filters in Excel<\/h3>\n
\n
1. Text Values in Excel<\/h4>\n
<\/a><\/p>\n<\/a><\/p>\n2. Numeric values in Excel<\/h4>\n
<\/a><\/p>\n<\/a><\/p>\n3. Date Values in Excel<\/h4>\n
<\/a><\/p>\n<\/a><\/p>\nFilter by Colors in Excel<\/h3>\n
<\/a><\/p>\nClear filter in Excel<\/h3>\n
<\/a><\/p>\n