Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the "subtotal" columns in XL in Office '07?
In older versions of XL (and sometimes in 2007), you could get those
"subtotal" trees or columns to the left of a spreadsheet. By clicking on the + and -, you could expand or contract the spreadsheet from detail level to subtotal level. How do you do that in 2007? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the "subtotal" columns in XL in Office '07?
It works for me when I use DataSubtotal. Why happens when you try it?
Regards, Fred. "Steve" wrote in message ... In older versions of XL (and sometimes in 2007), you could get those "subtotal" trees or columns to the left of a spreadsheet. By clicking on the + and -, you could expand or contract the spreadsheet from detail level to subtotal level. How do you do that in 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
What replaces the Office 2000 add-in "Access Form" in Office 2003 | Excel Discussion (Misc queries) |