I have a spreadsheet that has "+" and "-" signs down the right hand side and
along the top of the sheet.

This allows me to show/hide certain rows and columns.

How do I set something similar up on a new worksheet? I can't for the life
of me remember.

Thanks!

DataGroup And OutlineGroup

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"James Hamilton" wrote in message
...
I have a spreadsheet that has "+" and "-" signs down the right hand side
and
along the top of the sheet.

This allows me to show/hide certain rows and columns.

How do I set something similar up on a new worksheet? I can't for the life
of me remember.

Thanks!

Another way to get the outlining symbols down the left side is data|subtotals.

James Hamilton wrote:

I have a spreadsheet that has "+" and "-" signs down the right hand side and
along the top of the sheet.

This allows me to show/hide certain rows and columns.

How do I set something similar up on a new worksheet? I can't for the life
of me remember.

Thanks!

--

Dave Peterson

Thanks guys.

"James Hamilton" wrote:

I have a spreadsheet that has "+" and "-" signs down the right hand side and
along the top of the sheet.

This allows me to show/hide certain rows and columns.

How do I set something similar up on a new worksheet? I can't for the life
of me remember.

Thanks!