Expanding and collapsing rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Take a look at Data|Subtotals, too.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expanding / Collapsing rows 3
Expand and collapse 2
Protect worksheet but expand and collapse outline? 1
Word The More add-in for Microsoft Word 0
Collapsing rows via command button 2
Collapsing Rows 2
expand/collapse row button 3
HOW CAN I COLLAPSE AND EXPAND COLUMS 1

Back
Top