| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i expand and collapse rows
I need to expand and collapse ROWS, I want main info seen and rows below it
collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i expand and collapse rows
i keep trying but it's not working out very well!
?? -- Don Guillett Microsoft MVP Excel SalesAid Software "office wreck!" <office wrote in message ... I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i expand and collapse rows
Two options come to mind:
1) You can hide rows XL2003 http://office.microsoft.com/en-us/ex...CH062527931033 XL2007 http://office.microsoft.com/en-us/ex...CH100648381033 2) You can set a freeze pane so, as you scroll down, you continue to see headings at the top of the page XL2003 http://office.microsoft.com/en-us/ex...33#FreezePanes XL2007 http://office.microsoft.com/en-us/ex...33#FreezePanes -- Steve "office wreck!" <office wrote in message ... I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i expand and collapse rows
This is just what the subtotals command can be used for. If your data is in a
list, yiou can use the subtotals command to insert subtotals based on groups of data. You can expand or collaps the data groups that you want. The command is located on the Data menu in 2003 and the Data tab in 2007. -- Dave Herard MOS Master Instructor Microsoft Certified Trainer www.clicknlearnct.com "AltaEgo" wrote: Two options come to mind: 1) You can hide rows XL2003 http://office.microsoft.com/en-us/ex...CH062527931033 XL2007 http://office.microsoft.com/en-us/ex...CH100648381033 2) You can set a freeze pane so, as you scroll down, you continue to see headings at the top of the page XL2003 http://office.microsoft.com/en-us/ex...33#FreezePanes XL2007 http://office.microsoft.com/en-us/ex...33#FreezePanes -- Steve "office wreck!" <office wrote in message ... I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i expand and collapse rows
Yes, that might also be what the OP sought. The main point here would be to
uncheck the "summary data below" option to show data below the summary. -- Steve "DJH6064" wrote in message ... This is just what the subtotals command can be used for. If your data is in a list, yiou can use the subtotals command to insert subtotals based on groups of data. You can expand or collaps the data groups that you want. The command is located on the Data menu in 2003 and the Data tab in 2007. -- Dave Herard MOS Master Instructor Microsoft Certified Trainer www.clicknlearnct.com "AltaEgo" wrote: Two options come to mind: 1) You can hide rows XL2003 http://office.microsoft.com/en-us/ex...CH062527931033 XL2007 http://office.microsoft.com/en-us/ex...CH100648381033 2) You can set a freeze pane so, as you scroll down, you continue to see headings at the top of the page XL2003 http://office.microsoft.com/en-us/ex...33#FreezePanes XL2007 http://office.microsoft.com/en-us/ex...33#FreezePanes -- Steve "office wreck!" <office wrote in message ... I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i expand and collapse rows
Alta - YOU ROCK That is exactly what i needed!! thanks so much. my brain
fart lasted a lot longer than i thought, been a while since i needed to use that function, thanks so much! "AltaEgo" wrote: Yes, that might also be what the OP sought. The main point here would be to uncheck the "summary data below" option to show data below the summary. -- Steve "DJH6064" wrote in message ... This is just what the subtotals command can be used for. If your data is in a list, yiou can use the subtotals command to insert subtotals based on groups of data. You can expand or collaps the data groups that you want. The command is located on the Data menu in 2003 and the Data tab in 2007. -- Dave Herard MOS Master Instructor Microsoft Certified Trainer www.clicknlearnct.com "AltaEgo" wrote: Two options come to mind: 1) You can hide rows XL2003 http://office.microsoft.com/en-us/ex...CH062527931033 XL2007 http://office.microsoft.com/en-us/ex...CH100648381033 2) You can set a freeze pane so, as you scroll down, you continue to see headings at the top of the page XL2003 http://office.microsoft.com/en-us/ex...33#FreezePanes XL2007 http://office.microsoft.com/en-us/ex...33#FreezePanes -- Steve "office wreck!" <office wrote in message ... I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i expand and collapse rows
Hi,
This is also what pivot table often do and they are much more powerful and flexible than the Data, Subtotal command once you learn them. For example to expand and collapse the data under a particular category just double click the category row and all the detail is shown or hidden. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "office wreck!" wrote: I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's not working out very well! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expand Collapse Buttons | Excel Discussion (Misc queries) | |||
| Expand/Collapse Buttons for hidden rows or colums | Excel Discussion (Misc queries) | |||
| How do I move the expand/collapse for rows and columns in Excel? | Excel Worksheet Functions | |||
| Expand/Collapse Rows | Excel Worksheet Functions | |||
| Expand and Collapse Columns | New Users to Excel | |||
Linear Mode
