ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SubTotals or Outlines to the left? / on Top ? (https://www.excelbanter.com/excel-programming/328292-subtotals-outlines-left-top.html)

SIGE

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

Alok

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


SIGE

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



All times are GMT +1. The time now is 01:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com