Can Excel do this?

[dstock]

Hi I was wondering if anyone knows if excel can do this or not. What
want is basically to expand and contract cells. So first there will b
one row, and then hit something or somehow make it show more cells.
know I can lock cells and split both ways. I've attached an exampl
that will show exactly what I mean. Thanks

+-------------------------------------------------------------------
|Filename: excelforum example3.zip
|Download: http://www.excelforum.com/attachment.php?postid=3499
+-------------------------------------------------------------------

 

[Guest]

Try using Data->Group and Outline->Group.

If you select the rows you want to be able to hide or unhide just select the
rows or columns and then group them. You will then have little buttons in
the upper left corner with 1, 2, etc. that will allow you to open all of them
at once. Hope this is what you were looking for.

 

[dstock]

Thanks for the reply. That worked great . My second question, which
don't believe is possible, is it possible to only hide/unhide an
certain second of the block of cells. For example, if you have a 10X1
are you are working with, can I choose to hide/unide say the middle3X3
I don't believe this is possible because it HAS to assign rows an
columns for everything. Thanks

 

[dstock]

So I have grouped cells, but was wondering if it is possible for them to
pop up in stead of down. When I click + they always collapse down, is
there a way to have them collapse up instead?