Subtotal appears at the beginning instead of the end....
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? |
Subtotal appears at the beginning instead of the end....
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? |
Subtotal appears at the beginning instead of the end....
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? |
Subtotal appears at the beginning instead of the end....
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? |
All times are GMT +1. The time now is 02:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com