Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.3 Order and Group Cells and Ranges: Remove the Subtotals

graphic1

Data -> Outline-> Subtotal->Remove All

graphic2

Data: Remove the Subtotal

The previous pages demonstrated how to create and edit Subtotals. Here are the steps you can take to Remove a Subtotal.

 

Try it: Review the Subtotals

Select the entire spreadsheet.

Go to Data -> Outline-> Subtotal

 

What Do You See? You will be prompted to fill in the blanks for the Subtotal function. Look at the bottom of the window. There is an option that you can click to remove the Subtotal.

 

Try This, Too: Remove the Subtotals

Select: Remove All.

Click OK.

 

The Subtotals should be removed. This is a simple list in Excel, again. Very good.