Look at "Group and Outline" on the Data menu.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"GreenMonster"
wrote in message
I have a spreadsheet in which I'd like the ability to expand and collapse the
rows so row headers are only shown (Collapse) or the the data underneath each
header is shown (expand) Can Excel do this?
Thanks