Learn to create different kinds of Excel charts, from column, bar, and line charts to doughnut and scatter charts, with Excel for Mac 2016. Outline, and effects.

By 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: • 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: • 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. To ungroup, go to the same Group & Outline group on the Data tab and choose Ungroup→Ungroup or Clear Outline.

**Note: Outlook 2011 only supports about 3-4 signatures and a mail db under 5gb, this is not an archiving software. If you want to store more than 5gb in mail, look for an archiving software. Microsoft outlook 2011 for mac yosemite crashing.