View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to collapse rows in Excel,leaving a plus sign to open/close

Maybe you saw Data|subtotals in action--or Data|Group and Outline???

Both of these will show the outlining symbols to the left of the worksheet.

Exasperated and Requiring Assistance wrote:

I know how to hide / show the rows, but how do it so as to leave a little
plus sign in the corner that allows me to control the number of rows to
expand / contract (and I know you can do it - I've seen it on other
spreadsheets!)


--

Dave Peterson