Groups and Sub-totals in MS Excel 2013
Excel 2013 - Groups and Subtotals MS Excel can organize large amount of data of worksheets in groups , allowing you to show and hide different sections of your worksheet easily. And aslo to summarize the different groups using Subtotal command and create an outline in a worksheet To group rows or columns: 1. Select the rows or columns you want to group. Here we'll select columns A , B , and C . 2. Click the Data tab on the Ribbon , then click on the Group command . 3. The selected rows or columns will be grouped . To ungroup the grouped data , select the grouped rows or columns, then click on Ungroup command. To hide and show groups: 1. To hide a group, click the ...