It could be the subtotal function that's found on the DATA menu, if I'm
interpreting you question correctly.
--
Kevin Backmann


"NickPro72" wrote:

I have worked with workbooks before that have drop down boxes on the left
hand side that pull up extra rows when open and hide these rows when closed.
The drop down boxes are to the left of the row numbers and are in a grayed
out area. I am trying to create this gray area with drop down boxes. Any
idea how?