lgerick
New Member
- Joined
- Oct 8, 2008
- Messages
- 25
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi Excel guru's ... looking for some help on what is likely a simple issue but has me stumped!!
I am wanting to auto fill formulas in cells to the right of the original formula, but wanting the Column to stay the same and the Row to increase by 1.
for example .. there are 5 cells in question they are
A1 B1 C1 D1 E1
<TABLE style="WIDTH: 220pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=295 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" span=5 width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59 height=18><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:rect id=_x0000_s37894 style="MARGIN-TOP: -12.75pt; Z-INDEX: 6; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext 1pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37895 style="MARGIN-TOP: -12.75pt; Z-INDEX: 7; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37896 style="MARGIN-TOP: -12.75pt; Z-INDEX: 8; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37954 style="MARGIN-TOP: -12.75pt; Z-INDEX: 30; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37956 style="MARGIN-TOP: -12.75pt; Z-INDEX: 31; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37957 style="MARGIN-TOP: -12.75pt; Z-INDEX: 32; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37958 style="MARGIN-TOP: -12.75pt; Z-INDEX: 33; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37961 style="MARGIN-TOP: -12.75pt; Z-INDEX: 36; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37897 style="MARGIN-TOP: -12.75pt; Z-INDEX: 9; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37959 style="MARGIN-TOP: -12.75pt; Z-INDEX: 34; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37962 style="MARGIN-TOP: -12.75pt; Z-INDEX: 37; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37898 style="MARGIN-TOP: -12.75pt; Z-INDEX: 10; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37960 style="MARGIN-TOP: -12.75pt; Z-INDEX: 35; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37963 style="MARGIN-TOP: -12.75pt; Z-INDEX: 38; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
The Formula in A1 is =SUM(L26) and I would like to use Ctrl + R to
auto fill to the right and have the formula in B1 become =SUM(L27)
and in C1 become =SUM(L28) and in D1 become =SUM(L29) and then in
E1 become =SUM(L30)
but instead it is changing the column and not the row. I have tried
changing it to =SUM($L26) to maintain the column but that does not work
it does keep the column as L but gives the same formula all the way across;
The Formula in A1 is =SUM($L26) and I would like to use Ctrl + R to
auto fill to the right and have the formula in B1 become =SUM($L26)
and in C1 become =SUM($L26) and in D1 become =SUM($L26) and then in
E1 become =SUM($L26)
Any one know how I can make this work so that the formulas change
only the row and not the column.
example again:
<TABLE style="WIDTH: 220pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=295 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" span=5 width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59 height=18><v:rect id=_x0000_s37894 style="MARGIN-TOP: -12.75pt; Z-INDEX: 6; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext 1pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37895 style="MARGIN-TOP: -12.75pt; Z-INDEX: 7; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37896 style="MARGIN-TOP: -12.75pt; Z-INDEX: 8; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37954 style="MARGIN-TOP: -12.75pt; Z-INDEX: 30; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37956 style="MARGIN-TOP: -12.75pt; Z-INDEX: 31; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37957 style="MARGIN-TOP: -12.75pt; Z-INDEX: 32; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37958 style="MARGIN-TOP: -12.75pt; Z-INDEX: 33; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37961 style="MARGIN-TOP: -12.75pt; Z-INDEX: 36; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37897 style="MARGIN-TOP: -12.75pt; Z-INDEX: 9; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37959 style="MARGIN-TOP: -12.75pt; Z-INDEX: 34; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37962 style="MARGIN-TOP: -12.75pt; Z-INDEX: 37; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37898 style="MARGIN-TOP: -12.75pt; Z-INDEX: 10; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37960 style="MARGIN-TOP: -12.75pt; Z-INDEX: 35; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37963 style="MARGIN-TOP: -12.75pt; Z-INDEX: 38; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
The Formula in A1 is =SUM(L26) and I would like to use Ctrl + R to
auto fill to the right and have the formula in B1 become =SUM(L27)
and in C1 become =SUM(L28) and in D1 become =SUM(L29) and then in
E1 become =SUM(L30)
Thanking all in advance for you help and consideration
laura
I am wanting to auto fill formulas in cells to the right of the original formula, but wanting the Column to stay the same and the Row to increase by 1.
for example .. there are 5 cells in question they are
A1 B1 C1 D1 E1
<TABLE style="WIDTH: 220pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=295 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" span=5 width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59 height=18><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:rect id=_x0000_s37894 style="MARGIN-TOP: -12.75pt; Z-INDEX: 6; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext 1pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37895 style="MARGIN-TOP: -12.75pt; Z-INDEX: 7; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37896 style="MARGIN-TOP: -12.75pt; Z-INDEX: 8; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37954 style="MARGIN-TOP: -12.75pt; Z-INDEX: 30; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37956 style="MARGIN-TOP: -12.75pt; Z-INDEX: 31; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37957 style="MARGIN-TOP: -12.75pt; Z-INDEX: 32; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37958 style="MARGIN-TOP: -12.75pt; Z-INDEX: 33; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37961 style="MARGIN-TOP: -12.75pt; Z-INDEX: 36; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37897 style="MARGIN-TOP: -12.75pt; Z-INDEX: 9; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37959 style="MARGIN-TOP: -12.75pt; Z-INDEX: 34; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37962 style="MARGIN-TOP: -12.75pt; Z-INDEX: 37; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37898 style="MARGIN-TOP: -12.75pt; Z-INDEX: 10; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37960 style="MARGIN-TOP: -12.75pt; Z-INDEX: 35; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37963 style="MARGIN-TOP: -12.75pt; Z-INDEX: 38; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
The Formula in A1 is =SUM(L26) and I would like to use Ctrl + R to
auto fill to the right and have the formula in B1 become =SUM(L27)
and in C1 become =SUM(L28) and in D1 become =SUM(L29) and then in
E1 become =SUM(L30)
but instead it is changing the column and not the row. I have tried
changing it to =SUM($L26) to maintain the column but that does not work
it does keep the column as L but gives the same formula all the way across;
The Formula in A1 is =SUM($L26) and I would like to use Ctrl + R to
auto fill to the right and have the formula in B1 become =SUM($L26)
and in C1 become =SUM($L26) and in D1 become =SUM($L26) and then in
E1 become =SUM($L26)
Any one know how I can make this work so that the formulas change
only the row and not the column.
example again:
<TABLE style="WIDTH: 220pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=295 border=0 x:str><COLGROUP><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" span=5 width=59><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59 height=18><v:rect id=_x0000_s37894 style="MARGIN-TOP: -12.75pt; Z-INDEX: 6; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl24 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext 1pt solid; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37895 style="MARGIN-TOP: -12.75pt; Z-INDEX: 7; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37896 style="MARGIN-TOP: -12.75pt; Z-INDEX: 8; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37954 style="MARGIN-TOP: -12.75pt; Z-INDEX: 30; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37956 style="MARGIN-TOP: -12.75pt; Z-INDEX: 31; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37957 style="MARGIN-TOP: -12.75pt; Z-INDEX: 32; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37958 style="MARGIN-TOP: -12.75pt; Z-INDEX: 33; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37961 style="MARGIN-TOP: -12.75pt; Z-INDEX: 36; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37897 style="MARGIN-TOP: -12.75pt; Z-INDEX: 9; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37959 style="MARGIN-TOP: -12.75pt; Z-INDEX: 34; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37962 style="MARGIN-TOP: -12.75pt; Z-INDEX: 37; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl25 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD><TD style="BORDER-RIGHT: #eedfdf; BORDER-TOP: #eedfdf; BORDER-LEFT: #eedfdf; WIDTH: 44pt; BORDER-BOTTOM: #eedfdf; BACKGROUND-COLOR: transparent" vAlign=top align=left width=59><v:rect id=_x0000_s37898 style="MARGIN-TOP: -12.75pt; Z-INDEX: 10; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37960 style="MARGIN-TOP: -12.75pt; Z-INDEX: 35; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><v:rect id=_x0000_s37963 style="MARGIN-TOP: -12.75pt; Z-INDEX: 38; MARGIN-LEFT: 0px; WIDTH: 9pt; POSITION: absolute; HEIGHT: 13.5pt" o:insetmode="auto" strokecolor="windowText [64]" fillcolor="white [9]" filled="f"></v:rect><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eedfdf; BORDER-LEFT: windowtext; WIDTH: 44pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ff99cc" width=59 height=18 x:num>0</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
The Formula in A1 is =SUM(L26) and I would like to use Ctrl + R to
auto fill to the right and have the formula in B1 become =SUM(L27)
and in C1 become =SUM(L28) and in D1 become =SUM(L29) and then in
E1 become =SUM(L30)
Thanking all in advance for you help and consideration
laura