Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
After manipulating a spreadsheet I received from someone, I want to subtotal
by item. My subtotals appear at the beginning of the item instead of at the end. The grand total appears at the top of the spreadsheet instead of at the bottom. Can anyone tell me why this is happening and what I need to do in order to correct? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sara B,
When you do your subtotals, are you ensuring that the button for "Summary below data" is checked? DataSubtotalsSummary Below Data -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''''Yes'''' below. "sara b" wrote: After manipulating a spreadsheet I received from someone, I want to subtotal by item. My subtotals appear at the beginning of the item instead of at the end. The grand total appears at the top of the spreadsheet instead of at the bottom. Can anyone tell me why this is happening and what I need to do in order to correct? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you! I looked at this for a long time and never realized that wasn't
checked! "Thomas [PBD]" wrote: Sara B, When you do your subtotals, are you ensuring that the button for "Summary below data" is checked? DataSubtotalsSummary Below Data -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''''Yes'''' below. "sara b" wrote: After manipulating a spreadsheet I received from someone, I want to subtotal by item. My subtotals appear at the beginning of the item instead of at the end. The grand total appears at the top of the spreadsheet instead of at the bottom. Can anyone tell me why this is happening and what I need to do in order to correct? |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're welcome and thanks for the feedback.
-- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''''Yes'''' below. "sara b" wrote: Thank you! I looked at this for a long time and never realized that wasn't checked! "Thomas [PBD]" wrote: Sara B, When you do your subtotals, are you ensuring that the button for "Summary below data" is checked? DataSubtotalsSummary Below Data -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''''Yes'''' below. "sara b" wrote: After manipulating a spreadsheet I received from someone, I want to subtotal by item. My subtotals appear at the beginning of the item instead of at the end. The grand total appears at the top of the spreadsheet instead of at the bottom. Can anyone tell me why this is happening and what I need to do in order to correct? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro excel subtotal in subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |