Expanding and collapsing rows

Hello,

I have a spreadsheet categorized by date and I would like to know if there
is a way to expand and collapse the rows (i.e to give the user a manual way
to see, or not see the details in the rows).
The functionality I am looking for is similar to Outline Views in Ms Word.

Your help, as always, is greatly appreciated. Thank you.

Ed

Select the rows you want to collapse and Select Data, Group and an outline
will be created.
Gary

"Eduardo" wrote:

> Hello,
>
> I have a spreadsheet categorized by date and I would like to know if there
> is a way to expand and collapse the rows (i.e to give the user a manual way
> to see, or not see the details in the rows).
> The functionality I am looking for is similar to Outline Views in Ms Word.
>
> Your help, as always, is greatly appreciated. Thank you.
>
> Ed
>

Hi Ed,

You could explore the menu Data>Group & Outline>Group, etc.

Regards,
KL


"Eduardo" <[email protected]> wrote in message
news:[email protected]...
> Hello,
>
> I have a spreadsheet categorized by date and I would like to know if there
> is a way to expand and collapse the rows (i.e to give the user a manual
> way
> to see, or not see the details in the rows).
> The functionality I am looking for is similar to Outline Views in Ms Word.
>
> Your help, as always, is greatly appreciated. Thank you.
>
> Ed
>

Take a look at Data|Subtotals, too.

It'll add the outlining symbols, too--plus give you subtotals.

Eduardo wrote:
>
> Hello,
>
> I have a spreadsheet categorized by date and I would like to know if there
> is a way to expand and collapse the rows (i.e to give the user a manual way
> to see, or not see the details in the rows).
> The functionality I am looking for is similar to Outline Views in Ms Word.
>
> Your help, as always, is greatly appreciated. Thank you.
>
> Ed

--

Dave Peterson