Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fellow Wanderer
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Larry S
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarlosAntenna
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table drill down formatting matelot Excel Worksheet Functions 1 May 11th 06 01:28 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
Formatting dates in the future Compass Rose Excel Worksheet Functions 3 January 17th 05 10:39 PM
Pivot Table Drill Down Number Formatting Gregg Riemer Excel Discussion (Misc queries) 1 January 4th 05 10:53 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 11:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"