Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel do this?
Hi I was wondering if anyone knows if excel can do this or not. What I want is basically to expand and contract cells. So first there will be one row, and then hit something or somehow make it show more cells. I know I can lock cells and split both ways. I've attached an example that will show exactly what I mean. Thanks. +-------------------------------------------------------------------+ |Filename: excelforum example3.zip | |Download: http://www.excelforum.com/attachment.php?postid=3499 | +-------------------------------------------------------------------+ -- dstock ------------------------------------------------------------------------ dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225 View this thread: http://www.excelforum.com/showthread...hreadid=379100 |
#2
|
|||
|
|||
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" wrote: Hi I was wondering if anyone knows if excel can do this or not. What I want is basically to expand and contract cells. So first there will be one row, and then hit something or somehow make it show more cells. I know I can lock cells and split both ways. I've attached an example that will show exactly what I mean. Thanks. +-------------------------------------------------------------------+ |Filename: excelforum example3.zip | |Download: http://www.excelforum.com/attachment.php?postid=3499 | +-------------------------------------------------------------------+ -- dstock ------------------------------------------------------------------------ dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225 View this thread: http://www.excelforum.com/showthread...hreadid=379100 |
#3
|
|||
|
|||
Thanks for the reply. That worked great :). My second question, which I don't believe is possible, is it possible to only hide/unhide and certain second of the block of cells. For example, if you have a 10X10 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 and columns for everything. Thanks! -- dstock ------------------------------------------------------------------------ dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225 View this thread: http://www.excelforum.com/showthread...hreadid=379100 |
#4
|
|||
|
|||
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? -- dstock ------------------------------------------------------------------------ dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225 View this thread: http://www.excelforum.com/showthread...hreadid=379100 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |