In MS Excel, you can group and sub-group Columns (and also Rows) which will be very helpful to look at summary data in one screen , with the option of looking at the selected detail columns / rows of user choice, at the click of a button above the grouping rows/columns. After filling the sheet with the required data across required columns and rows, the user has to select the required set of columns (example A to D), and select DATA -> GROUP AND OUTLINE -> GROUP option. This will group the four columns and will show a + mark at the top of column D. If the user wants to see the detail data present in Columns A / B / C / D , he needs to click that + button to Expand. On doing this, all the four columns will be displayed, and a _ sign will be shown on D column top. On clicking this , the user will be able to Hide details of column A / B / C. Similarly you can group rows data also.





No user commented in " Grouping facility in MS Excel "
Follow-up comment rss or Leave a TrackbackLeave A Reply