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.