Teir setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 27 Apr 2006 19:06 GMT

I have seen other spreadsheets like this, but don't know how to do it. I
want the following:
CISTERNOGRAM
341DIAG
    CISTERNOGRAM    78630    340NUC
    INJECTION OF MAT(CISTERNOGRAM)    62311    369APEC
to be able to collapse (with the arrow on left side like the joined
information in a dbase) and appear:
+ CISTERNOGRAM (EXP CODE)      341DIAG

so that when I click in the arrow, it will expand to show the first view.

Thank you for any help you can give me.

Reply to this Message

Pete_UK - 28 Apr 2006 23:38 GMT

When you use Data | Subtotals you can select different levels of detail
to view, and this may be what you have seen - Excel uses an "Outline"
to do this. For further details of how to set this up in different
circumstances use Excel Help and search for outline.

Hope this helps.

Pete

Reply to this Message

Mark - 01 May 2006 15:04 GMT

Thank you.

> When you use Data | Subtotals you can select different levels of detail
> to view, and this may be what you have seen - Excel uses an "Outline"
[quoted text clipped - 4 lines]
>
> Pete

Reply to this Message

Pete_UK - 01 May 2006 15:22 GMT

You're welcome.

Pete

Reply to this Message