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.
Excel 2011 For Mac Tutorial Video
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:
Solver for Excel 2011 for Mac matches the functionality and user interface of Solver for Excel 2010 for Windows. Excel workbooks containing Solver models and VBA macros controlling Solver can be created in Windows and used on the Mac, and vice versa. On the topmost menu, choose Excel Close and Return to Microsoft Excel. Solution for VBA problems: Completely remove the Mac Office 2011 suite and then reinstall the whole suite without using the Migration Assistant. This solution was recommended by XinXin Liu, Test Lead for Mac Excel, Macintosh Business Unit, Microsoft.
Select the rows that contain the tables with Total Rows turned on.
Tables need at least one empty row between them as separators. Contracted rows may not be included in Total Row calculations.
On the Ribbon’s Data tab, go to the Group & Outline group and choose Group→Auto Outline.
Excel turns on the group controls in a new margin.
To use the new controls, here’s what you do:
Excel 2011 For Mac Macros
Click the 1 button at the top of the new margin to contract all groups. A plus sign displays next to the Total Row of each contracted group.
Click the + and – signs in the margin to expand or contract individual tables.
Click the 2 button at the top of the new margin to expand all groups.
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.
Excel 2011 For Mac
To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.