Drill Down Formatting

G

Guest

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!
 
L

Larry S

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

CarlosAntenna

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table drill down formatting 1
Pivot table drill down sort 0
Pivot table drill down data 2
How to design a drill-down grid ? 4
sort order of pivot table drill down 0
Pivot Table: Resulting Column Widths on Drill Down 0
Show search results within form + drill down to detail form 2
Drill down using DAO 2

Top