Windows XP

 Windows 7

# Microsoft Excel 2010 : Formatting Subtotals, Applying Multiple Subtotal Function Types (part 1)

12/3/2013 3:13:18 AM

### 1. Formatting Subtotals

If you hide the data rows, select the subtotals, and apply formatting to them, all the data, including the hidden data rows, will reflect the new formatting. To format just the subtotals, select only the visible cells.

#### Applying Formatting to Only the Totals

To copy just the totals to a new location, follow these steps:

 1 Click the outline icon so that only the rows to format are visible. 2 Select the entire dataset. If you don’t want to apply the formatting to the header row, do not include it in the selection. 3 Go to Home, Editing, Find & Select, Go to Special, and select Visible Cells Only. 4 Apply the desired formatting.

A shortcut for step 3 is to press ALT+; (semicolon).

### 2. Applying Multiple Subtotal Function Types

A dataset can have more than one type of subtotal applied to it—for example, a sum subtotal of one column and a count subtotal of another. Make sure the Replace Current Subtotals option in the Subtotal dialog is deselected so that each subtotal will be applied separately. Each subtotal will be calculated and placed on its own row, pushing any existing subtotal row down, as shown in Figure 1.

#### 2.1 Applying Multiple Subtotal Function Types

To apply multiple subtotals to a dataset, follow these steps:

1.
Sort the data by the column the summary should be based on. For example, if summarizing by region, sort the Region column.

2.
Select a cell in the dataset.

3.
Go to Data, Outline, Subtotal.

4.
From the At Each Change In field, select the column by which to summarize the data.

5.
From the Use Function field, select the function to calculate the totals by.

6.
From the Add Subtotal To field, select the columns the totals should be added to. Notice that, by default, the last column is already selected.

7.
Click OK.

8.
Go to Data, Outline, Subtotal.

9.
Deselect Replace Current Subtotals.

10.
Repeat steps 4 to 6, selecting a new function from the Use Function field.

11.
Click OK. The dataset will reflect two subtotals.
 Other -----------------

 REVIEW

 VIDEO TUTORIAL

Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
 Top 10