Fold/unfold rows in a worksheet

[juannavarroperez]

I've got an Excel file which comes with some nice icons on the
righthand side to fold/unfold hidden rows. Does anybody know how is it
possible to get this "+" and "-" icons. The file does not seem to
include any macros. I can not post the .xls file because it contains
confidential data, but you can see a snapshot of the relevant part here

http://juannavarroperez.googlepages.com/excelshot.PNG

Thanks for any help.

 

[Niek Otten]

Data>Group and outline

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I've got an Excel file which comes with some nice icons on the
| righthand side to fold/unfold hidden rows. Does anybody know how is it
| possible to get this "+" and "-" icons. The file does not seem to
| include any macros. I can not post the .xls file because it contains
| confidential data, but you can see a snapshot of the relevant part here
|
| http://juannavarroperez.googlepages.com/excelshot.PNG
|
| Thanks for any help.
|

 

[Dave Peterson]

Another way to get those outlining symbols is to sort your data by a key column
and then use data|subtotals.

You'll get, er, subtotals as well as those outlining symbols to the left.

 

[juannavarroperez]

Cheers,

Thanks all for the quick replies.