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.

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.

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.