| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SubTotals or Outlines to the left? / on Top ?
Hi There,
When grouping Rows: eg row 4 & 5... the "Summary Row" will be the row underneath: eg Row 6. Is it possible to have Row 3 as "Summary Row"? Similar for Columns: Column B & C ... "Summary column" is D. Possible to get Column A as...? It would surprise me ... (though help me)... but you have already surprised me before! :o) Cheers Sige |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SubTotals or Outlines to the left? / on Top ?
Hi,
Just clear the check box "Summary below data" "SIGE" wrote: Hi There, When grouping Rows: eg row 4 & 5... the "Summary Row" will be the row underneath: eg Row 6. Is it possible to have Row 3 as "Summary Row"? Similar for Columns: Column B & C ... "Summary column" is D. Possible to get Column A as...? It would surprise me ... (though help me)... but you have already surprised me before! :o) Cheers Sige |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SubTotals or Outlines to the left? / on Top ?
1. The settings for the Outlines can be changed in:
Group= Outlines=Settings = Click the "Directions" you want ... 2. For Subtotals: In the Subtotals-dialog box = Check/ Uncheck Summary Below data (SIGE) wrote in message . com... Hi There, When grouping Rows: eg row 4 & 5... the "Summary Row" will be the row underneath: eg Row 6. Is it possible to have Row 3 as "Summary Row"? Similar for Columns: Column B & C ... "Summary column" is D. Possible to get Column A as...? It would surprise me ... (though help me)... but you have already surprised me before! :o) Cheers Sige |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No plus or minus signs to left of subtotals | Excel Worksheet Functions | |||
| excel - outlines | Excel Worksheet Functions | |||
| Excel subtotals do not show on left of row numbers | Excel Worksheet Functions | |||
| Sorting Outlines | Excel Worksheet Functions | |||
| Insert-Subtotals makes Column Outlines disappear | Excel Worksheet Functions | |||
Linear Mode
