Hello,

i saw a spreadsheet where they collumns could be collapsed as if they used subtotals with a plus or a minus.

Subtotals open enclose vertically, here they open en close vertically and there is no reason for a subtotal.

How could they do it.

Tnx

Select your data range you would like to group. On the menu bar select Data
Group and outline. That's should do it.
--
If u change the way u look @ things, the things u look at change.


"zekni" wrote:

Hello,

i saw a spreadsheet where they collumns could be collapsed as if they used subtotals with a plus or a minus.

Subtotals open enclose vertically, here they open en close vertically and there is no reason for a subtotal.

How could they do it.

Tnx

Hi zekni,

To hide/unhide certain columns then
Select column(s), Format, Columns, Hide/unhide column

You can record a macro, put the code into an event macro and
toggle the hiding or unhiding of columns with a double-click event.

Example:

Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
'to install -- right-click on the sheet tab of the sheet to
' be used in and choose 'view code'. Paste this Worksheet
' event macro into the module. 2007-05-11 misc
'http://www.mvps.org/dmcritchie/excel/event.htm
Cancel = True 'get out of entry mode
If Range("A1").Interior.ColorIndex < 0 Then
Range("B:B,D:E,H:H").EntireColumn.Hidden = True
Range("A1").Interior.ColorIndex = 35
Else
Cells.EntireColumn.Hidden = False
Range("A1").Interior.ColorIndex = -1
End If
End Sub

Since I don't know how to test to see if any columns are hidden
I changed the interior color of cell A1, there would be ways of
being less conspicuous, but thought maybe the fact that it
is conspicuous might be helpful.

--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"zekni" wrote in message ...
Hello,

i saw a spreadsheet where they collumns could be collapsed as if they used subtotals with a plus or a minus.

Subtotals open enclose vertically, here they open en close vertically and there is no reason for a subtotal.

How could they do it.

Tnx

Hi zekni,
see answer in newsgroup, please post in plain text
not in HTML. You can see how HTML messed up
Google Groups archives, where the other replies show
"quoted text", and my reply doesn't even show
comment delimiters.

http://groups.google.com/groups?thre...GP06.p hx.gbl

Turning off MIME/HTM/RichTextFormat in Outlook Express
http://www.mvps.org/dmcritchie/excel....htm#nomimeoe6

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

all of the following should be preceded by a comment delimiter ("")
at the beginning of each line after the next line, which would be
the case had you posted in plain text.

"zekni" wrote in message ...
Hello,

i saw a spreadsheet where they columns could be collapsed as if they used subtotals with a plus or a minus.

Subtotals open enclose vertically, here they open en close vertically and there is no reason for a subtotal.

How could they do it.

Tnx

Thank you gentlemen

It works

Zekni

"zekni" schreef in bericht ...
Hello,

i saw a spreadsheet where they collumns could be collapsed as if they used subtotals with a plus or a minus.

Subtotals open enclose vertically, here they open en close vertically and there is no reason for a subtotal.

How could they do it.

Tnx

Thank you.

It works

Zekni


"zekni" schreef in bericht
...
Hello,

i saw a spreadsheet where they collumns could be collapsed as if they used
subtotals with a plus or a minus.

Subtotals open enclose vertically, here they open en close vertically and
there is no reason for a subtotal.

How could they do it.

Tnx