From Leo's mailbag:
> From: A Computer User
> Sent: February 12, 2007
> To: Ask Leo!
> Subject: Re: Ask Leo Question - creating Outlines in excel
>
> Leo,
> Sorry if the Excel question I am about to ask is already on your site,
> it's just that if I knew what it is I could research it myself (and
> Excel won't 'Help' me). I have been sent a spreadsheet where you can
> hide and expand groups of rows (or columns?) by '+' and '-' icons in
> the grey bar to the left of the row identifiers. When expanded, the
> rows in the same grouping are linked visually by a virtical line. There
> are also 'level' numbers above these icons, also in the grey bar that
> you can click to expand or close all row groupings defined at that
> level. I am familiar with the manual 'Hide/unhide' option, but would
> like to use this easier functionality in my excel spreadsheets. Can you
> tell me what this facility is called, and where I can look to find out
> more about it please?
I believe what you're looking for is called an "outline". A quick search
in Excel help returned topics, including "creating an outline" which had
a diagram of exactly what you've described :-)
Thanks for asking,
Leo
Article 1486
| Category:
Microsoft Office
