![]() |
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! |
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! |
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