ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Drill Down Formatting (https://www.excelbanter.com/excel-worksheet-functions/89205-drill-down-formatting.html)

Fellow Wanderer

Drill Down Formatting
 
I have used spreadsheets in the past that have a range of rows that can
collapse or expand in order to view more details. They had a "+" and "-"
indicator by the row number that you could click on to drill down. Similar
to how this chat room works when you follow a string of messages.

How do I make this happen?

Thanks!



Larry S

Drill Down Formatting
 
This is a feature known as "Subtotals" found under the "Data" command at the
top of your screeen.


"Fellow Wanderer" wrote in
message ...
I have used spreadsheets in the past that have a range of rows that can
collapse or expand in order to view more details. They had a "+" and "-"
indicator by the row number that you could click on to drill down.
Similar
to how this chat room works when you follow a string of messages.

How do I make this happen?

Thanks!





CarlosAntenna

Drill Down Formatting
 
If you are working with text entries rather than numbers that can be
subtotaled, you could use Data Group and Outline.

--
Carlos

"Fellow Wanderer" wrote in
message ...
I have used spreadsheets in the past that have a range of rows that can
collapse or expand in order to view more details. They had a "+" and "-"
indicator by the row number that you could click on to drill down.

Similar
to how this chat room works when you follow a string of messages.

How do I make this happen?

Thanks!






All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com