Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Collapse control
I have a spreadsheet that someone sent me and it has a box with a line
extending from it that indicates a "range" of rows. If you click the box the range collapse and if you click the box again it expands to show all the rows again. i have never used this before and I can't figure out how to insert one of my own or alter the range of the rows affected. I don't even know what it is called to be able to look it up in the "help" files. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Collapse control
Try Data Group and Outline
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "GatorVTX" wrote: I have a spreadsheet that someone sent me and it has a box with a line extending from it that indicates a "range" of rows. If you click the box the range collapse and if you click the box again it expands to show all the rows again. i have never used this before and I can't figure out how to insert one of my own or alter the range of the rows affected. I don't even know what it is called to be able to look it up in the "help" files. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Collapse control
GatorVTX wrote:
I have a spreadsheet that someone sent me and it has a box with a line extending from it that indicates a "range" of rows. If you click the box the range collapse and if you click the box again it expands to show all the rows again. i have never used this before and I can't figure out how to insert one of my own or alter the range of the rows affected. I don't even know what it is called to be able to look it up in the "help" files. Sounds like grouping. To create this in Excel 2003 and prior, select a range of rows or columns, then Data | Group and Outline | Group (similar to remove an existing group). Not sure about Excel 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel spin box - no Control tab in Format Control dialong box | Excel Worksheet Functions | |||
Difference between a Forms Control verus Active-X Control | Excel Discussion (Misc queries) | |||
Collapse Rows? | Excel Discussion (Misc queries) | |||
Collapse and expand data | Excel Worksheet Functions | |||
Help Screens collapse | Setting up and Configuration of Excel |