I'm trying to group dates by week within a pivot table (Excel for Mac). I know how to do this in Excel for Windows, but the interface is different. Right click on one of the date in the Date column of the Pivot Table, and select Group and Outline Group.
Sometimes it's needed to create several sheets with the same formatting. E.g., to create a workbook where content of a particular sheet is sales in a particular month. Hard way is to create one sheet, format it and then copy all formatting between sheets manually. Easy way is to group several sheets and format all of them simultaneously.
To group sheets, click one of the tabs that you want in the group and press the Ctrl key. With the Ctrl key held down, click the remaining tabs in the intended group of sheets. All the grouped sheets tabs will turn white, and the indicator [Group] will appear in the title bar after the workbook name:
To group a consecutive series of sheets, click the tab of the first sheet you want grouped, and then hold down the Shift key as you click the last tab of the sheet you want in the series. All the sheets between the first and last tab will be included in the group.
You can group all the sheets in a workbook by right-clicking any sheet tab and choosing Select All Sheets from the shortcut menu:
To ungroup grouped sheets, click a sheet tab outside of the group, or right-click any of the grouped tabs and choose Ungroup Sheets from the shortcut menu.
The following items point out things that happen on all sheets when sheets are grouped:
Note: When entering group content, be sure to enter only the content that you want to be common to all the sheets in the group. If the group of sheets is intended to be quarterly sales reports for two or more month, for example, stop entering group content and ungroup the sheets before entering any content specific to any individual month.
In Office 2011 for Mac, use Excel’s Group tool to identify ranges of rows in worksheets that you can then turn on and off. Activate the rows by using switches in a new margin that’s displayed when Group is active. Group is particularly useful when you have large tables with Total Rows turned on because it lets you hide data rows to reduce visual clutter on a busy worksheet.
To group an Excel worksheet that has multiple data tables that all begin flush left (or at least in the first few columns), do the following:
To use the new controls, here’s what you do:
You can select a range of adjacent rows within a single table and on the Ribbon’s Data tab; go to the Group & Outline group and choose Group→Group to group just the selected rows.
To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |