There are two ways to do this... One is grouping and the other one is outline. Both options can be found under the Data menu. The main difference between the methods is that outlining requires either a summary row or column and it would collapse the details based on the sums either vertically or horizontally.
-R!
>hi all,
>I have an excel sheet that i do my personal budget on. i want to expand on it for next year to include more information but it wil be too long to fit on the screen so what i want to do is use groupings. i have seen excel sheets that have a feature like on the thread here where by you can click on an + at the side and it expands the section or a - and it contracts it. can anyone point my in the right direction to setting this up.
>Slán
>~M
Ricardo A. Parodi
eSolar, Inc.