Home |
Search |
Today's Posts |
#1
|
|||
|
|||
multi group with summary above with 1 overall summary line below
Is it possible to setup, on a given spreadsheet, groups so that 4 or 5
categories (for example) are summarized with the (bolded) title line above the detail for each section but with the overall summary line for the spreadsheet (i.e. the "bottom line") appears at the bottom of the sheet; or, in other words, change the setting of the groupings to be different on the same sheet? |
#2
|
|||
|
|||
multi group with summary above with 1 overall summary line below
Hi - you need to be more specific, your question is not clear. -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=480901 |
#3
|
|||
|
|||
multi group with summary above with 1 overall summary line bel
"bob777" wrote:
Hi - you need to be more specific, your question is not clear. What I mean is this: I'm using the group/outline feature of excel. You set up the summary row either above or below a group of rows (i.e. select the rows to be summarized then group/outline them so that they can be hidden (by clicking the +/- button) and only the summary row is displayed). This is a very useful feature when dealing with very long spreadsheets. There is one option that enables you to select whether the summary row is the one directly above or directly below the rows to be summarized (and selected just previous their grouping). Unfortunately, it seems that the option that lets you select the location of tha summary row (i.e. above or below the rows that are summarized) applies to the whole spreadsheet, not just a single set of rows in that spreadsheet. I'd like to know if there is a way to change that option on a single group of rows in that spreadsheet to be different than other groups of rows on that same spreadsheet so that, for example, that one group of rows has its summary row above it, and all other grouped rows in that spreadsheet have their summary row below the groups. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a group of lines into one line without merging | Excel Discussion (Misc queries) | |||
have a summary sheet that needs to link to every ten line on the . | Excel Worksheet Functions | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
pivot table multi line chart | Charts and Charting in Excel |