ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Expand/Hide Data + and - Sign (https://www.excelbanter.com/excel-discussion-misc-queries/88764-expand-hide-data-sign.html)

James Hamilton

Expand/Hide Data + and - Sign
 
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!

Bob Phillips

Expand/Hide Data + and - Sign
 
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!




Dave Peterson

Expand/Hide Data + and - Sign
 
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

James Hamilton

Expand/Hide Data + and - Sign
 
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!



All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com