go to a new workbook.

select several adjacent columns

go to
Data=Group and Outline and click the group button



--
Regards,
Tom Ogilvy


"mnt" wrote:

Someone sent me a workbook with a worksheet that has an area above the column
heading letters in which two buttons appear. These buttons are labeled 1 and
2. Clicking on 2 displays rows that are hidden and shows a spanning line
over those columns. Clicking on 1 hides those rows.

I've searched for Custom Views, macros, etc. and can't find anything that is
the definition of these buttons. How can something like this be created? I
can email a jpg of the worksheet to show the buttons, if this is not clear.

Thanks.