showing total only hiding detail rows in Excel

Q116. In Excel, how can I show summary reports with Totals only hiding all the rows containing the details?

For example, I have a raw data table that has details of all trips undertaken by all drivers with a Totals row. I want to show only the Totals rows (Rows 3, 9 and 13) for each driver.

excel showing total only hiding detail rows

To do it in Excel, here is the answer:

a) Click on "Group" under "Data". Click on "Auto Outline".

excel excel showing total only hiding detail rows

b) A new section is added to the left of the screen. This section has "Outline" controls.

excel excel excel showing total only hiding detail rows

c) Clicking on "-" control, hides all details rows as shown below.

excel excel excel excel showing total only hiding detail rows


You can find similar Excel Questions and Answer hereunder

1) After several iterations, I have finalized my WorkBook - how do I make it Read-only from then on to prevent further edits?

2) I want to add a trend indicator symbol next to my sales data - how can I do that?

3) how to write a formula in Excel

4) How can I add and link a Chart Title to a cell value?

5) Applying a countif formula only to visible cells in a filtered list in Excel

6) I have a very complex macro that runs for a long time - is there any way I can set up an audible alarm indicating macro run is over?

7) Can I change the way that huge numbers are displayed in Y-Axis so that they do not take up chart space?

8) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

9) I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?

10) How can I find the slab in which a given value fits?

11) How can I shade alternate rows in color using VBA to make it easier to read voluminous data running into hundreds of rows?

12) How can I extract file name from a full path?

13) Vba list all files in a folder in Excel

14) How can I remove display of Gridlines in my worksheet using VBA?

15) I am planning to protect my sheet using a password. However, for select cells I would like users to be able to edit the cells. In Excel, how can I achieve that?