Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table drill down formatting | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |