Tags: excel, file, fold, hidden, icons, microsoft, msdn, righthand, rows, software, unfold, worksheet

Fold/unfold rows in a worksheet

On Microsoft » Microsoft Excel

2,087 words with 3 Comments; publish: Thu, 22 May 2008 04:18:00 GMT; (30663.48, « »)

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.

All Comments

Leave a comment...

  • 3 Comments
    • Data>Group and outline

      --

      Kind regards,

      Niek Otten

      Microsoft MVP - Excel

      <juannavarroperez.excel.todaysummary.com.gmail.com> wrote in message news:1161694343.363059.209050.excel.todaysummary.com.k70g2000cwa.googlegroups.com...

      | 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.

      |

      #1; Thu, 22 May 2008 04:19:00 GMT
    • 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.excel.todaysummary.com.gmail.com wrote:

      > 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

      #2; Thu, 22 May 2008 04:20:00 GMT
    • Cheers,

      Thanks all for the quick replies.

      #3; Thu, 22 May 2008 04:21:00 GMT