format question

[deskjet830c]

I am running office 2007, In excel I created a budget
row 1 is a header for a category example food, then rows 2 to 9 the details one enters to track what you spend. , row 10 a new category header rows 11-19 the detail row 20 a 3rd header etc.
I want to have it formatted so only the header are visible until you click (or double click) on that on a header and teh detail rows expand.
example click row 1 it expands rows 2-9 then you can enter the details. then click on the next header say row 30 rows 31-31 open up and rows 2-9 will close.. when you save it would hide all detail rows and only have the header rows visible... Hope I made this clear is that possible? ,

[FDibbins]

Hi and welcome to the forum

Try playing around with GROUPS (Data/Outline/Group)

[deskjet830c]

Thanks I will try the groups it should work