View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default No plus or minus signs to left of subtotals

Hi,

I think the short cut key is Ctrl+8

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Staceyglow" wrote in message
...
Lately, when I use the subtotal function, it does the subtotalling I want,
but I don't get the plus or minus signs on the left of the spreadsheet to
collapse or expand the data. I don't know if a setting accidentally got
changed or what. Can anyone help me?