| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No plus or minus signs to left of subtotals
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
No plus or minus signs to left of subtotals
In xl2003 menus, I'd check here first.
Tools|Options|View tab|check Outlining symbols. Staceyglow wrote: 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? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Plus and Minus signs in my additions and subtraction | New Users to Excel | |||
| MINUS SIGNS REMOVAL | New Users to Excel | |||
| strip minus signs from right to left | Excel Discussion (Misc queries) | |||
| I want to get brackets round my figures not minus signs | Excel Discussion (Misc queries) | |||
| Importing values w/trailing minus signs | Excel Discussion (Misc queries) | |||
Linear Mode
