Data -> Outline-> Subtotal->Remove All Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.2. Apply data analysis: Subtotal 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.