Drill Down Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
This is a feature known as "Subtotals" found under the "Data" command at the
top of your screeen.
 
If you are working with text entries rather than numbers that can be
subtotaled, you could use Data> Group and Outline.
 
You must log in or register to reply here.

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

Cordless drill recommendation 5
Pivot table drill down formatting 1
Pivot table drill down sort 0
Drill Down Features 2
Pivot table drill down data 2
Pivot Table Drill Down 1
Pivot table - drill down - format 0
Drill to Details - is there user friendly way to delete the sheet 1

Back
Top