Printing group symbols on report

How can I get the group symbols to print on my reports?
The group symbols and marks show where one can
collapse/expand sets of rows/columns to hide/reveal
rows/columns. I've looked everywhere for instructions to
do this and have not been successful. Would appreciate
any help anyone can render. Thanks. Jim

AFAIK, there's nothing built in that lets you print with the symbols
visible. However, you could create a User Defined Function, and use it
to display symbols in the first couple of columns.

For example, enter the following function in a module sheet:

Function ShowLevel(rng As Range) As Integer
ShowLevel = rng.EntireRow.OutlineLevel
End Function

Then, in cell A2 on the sheet with the outline, enter the following formula:

=IF(ShowLevel(A2)=COLUMN(),"+","|")

Copy the formula across to cell B2, and down to the last row of data.

Centre the data in the cell, and it will resemble the outline symbols.

Jim Goughenour wrote:
How can I get the group symbols to print on my reports?
The group symbols and marks show where one can
collapse/expand sets of rows/columns to hide/reveal
rows/columns. I've looked everywhere for instructions to
do this and have not been successful. Would appreciate
any help anyone can render. Thanks. Jim


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html