if A1 contans the data header "Dates"
and B2-B7 contains the data that is to be "expanded/collapsed" then do I
group all cells A1-B7 using Data\Group & Outline\Group?

Sorry, the help section doesn't do a very good job explaining it.

"Jim Cone" wrote:

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