#1   Report Post  
Todd
 
Posts: n/a
Default data grouping

Hi. I am learning to group and outline data and wonder if there is a
tutorial or anything out there? Right now I use the auto outline but I don't
understand how it organizes things. I seem to get the same outline no matter
if the data headers are in the same column or seperated.


Thanks,


Todd
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Perhaps two Help topics will help you out:
Create an outline
About Outlining a worksheet

tj

"Todd" wrote:

Hi. I am learning to group and outline data and wonder if there is a
tutorial or anything out there? Right now I use the auto outline but I don't
understand how it organizes things. I seem to get the same outline no matter
if the data headers are in the same column or seperated.


Thanks,


Todd

  #3   Report Post  
Todd
 
Posts: n/a
Default

Thanks,

My situation is that I need to group 4 layers deep and all my cells do not
have formulas. The auto outline groups only two levels on this sheet, and
the manual grouping skips either one or many rows in the 4th level.

The help section is where I started. I don't see where it explains why it
misses some rows or includes many rows instead of only the ones I select.



Todd




"tjtjjtjt" wrote:

Perhaps two Help topics will help you out:
Create an outline
About Outlining a worksheet

tj

"Todd" wrote:

Hi. I am learning to group and outline data and wonder if there is a
tutorial or anything out there? Right now I use the auto outline but I don't
understand how it organizes things. I seem to get the same outline no matter
if the data headers are in the same column or seperated.


Thanks,


Todd

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
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 05:17 AM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Charting data ranges that change mikelee101 Charts and Charting in Excel 2 December 16th 04 11:07 PM
Grouping data within intervals Cartesio Excel Worksheet Functions 0 November 2nd 04 01:45 PM


All times are GMT +1. The time now is 01:17 AM.

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

About Us

"It's about Microsoft Excel"