View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Tom Atkins Tom Atkins is offline
external usenet poster
 
Posts: 1
Default How to collapse rows in Excel,leaving a plus sign to open/close

I don't know what you want

On Wednesday, April 11, 2007 9:04 PM Exasperated and Requiring Assistanc 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!)



On Wednesday, April 11, 2007 9:40 PM Dave Peterson wrote:


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:

--

Dave Peterson



On Wednesday, April 11, 2007 10:14 PM ExasperatedandRequiringAssistanc wrote:


Thanks mate - u r a deadset legend

My display name is now no longer "Exasperated and Requiring Assistance" but,
"Cool, Calm and Collected"

Much obliged ;)

"Dave Peterson" wrote: