- GROUP AND UNGROUP FEATURE ON THE DATA TOOLBAR IN 2010 HOW TO
- GROUP AND UNGROUP FEATURE ON THE DATA TOOLBAR IN 2010 PLUS
Select Sheet1, press down the SHIFT key, and select Sheet4.Suppose you have a set of sheets with sales information for different years and you need to calculate the total sales for each day.Īll the sheets, in this case, have the same columns, so the fastest way to work would be to group them together: If you want to select all the sheets in a workbook, right-click any sheet tab and click on “ Select All Sheets” from the popup menu that appears.If the worksheets you want to group are all adjacent to one another, as shown in the image below, then click the first sheet’s tab, hold down the SHIFT key on your keyboard and click the last sheet’s tab.After you’re done click the last tab, you can release the CTRL-key. Hold down the CTRL key of your keyboard and click the tabs of each sheet you want to group together one by one.Here are two easy ways in which you can group worksheets together in Excel: Grouping worksheets is easier than you think. Once the worksheets are grouped, you can enter the same data, make the same changes, write the same formulas and apply the same formatting to all the worksheets at once without having to switch through different sheets and edit each one individually. You can move, copy, or delete a whole group of sheets at the same time.You can apply the same formatting to all the sheets (for uniformity).You can put the same formulas to all the sheets at once.You can edit existing data on multiple worksheets at the same time.You can enter the same data to all the sheets at the same cell locations.Here are some of the things that you can do with grouped sheets: When you group a set of worksheets together, you can perform the same operations to all the sheets in the group. Grouping gets things done quicker when working with a set of identically structured sheets. There are a number of reasons why Excel users like to group worksheets.
GROUP AND UNGROUP FEATURE ON THE DATA TOOLBAR IN 2010 HOW TO
GROUP AND UNGROUP FEATURE ON THE DATA TOOLBAR IN 2010 PLUS
When you clicked on the minus sign ( –), it collapsed the group and changed it to a plus sign ( +).ī. Click on the minus sign (-) to collapse the group.Ī. You will notice that Excel created a new margin with a set of dots next to each row, you will also notice that it created a small box with a minus sign indicating that the group is expanded.Ī. Click on the Group button located in the Outline Group Click on the Data tab located in the Ribbonģ. Select a set of rows that you wish to group together.Ģ. I will show you the two methods that can be used to add comments to cells in Excel, one involves the right-click menu and the other the Office Ribbon menu.ġ. Note: I used Excel 2007 when creating this tutorial. If you have any comments or questions please post them below. This can be extremely useful when you are working with a spreadsheet that has multiple years of data, think of it, if you had 7 years of data by month – that would amount to 84 rows of months and 7 with totals …instead of dizzying someone with all that data you can group it and display the totals per year and show off your skills with Excel. Say you have several rows with the sales figures by month and the last row is a summation of the data, rather than display all months you can group the data (months) and only display the row with the totals. Outlining and grouping rows or columns in Excel makes it easy to organize and declutter spreadsheets that have a ton of data on display.
0 kommentar(er)
