| View previous topic :: View next topic |
| Author |
Message |
open.kinda.guy
Newbie
Joined: 24 Dec 2005
Posts: 1
|
 Posted: Sat Dec 24, 2005 4:03 pm Post subject: Relative Reference HELP |
 |
|
I feel like a simpleton.
In excel if i wanted a relative reference spanning many rows all I had to do is
R[-2]C[3]
Then select all the rows and do a ctrl enter and Wallah.
I cannot for the life of me accomplish this in OO
I just want to sum colums C thru G into K on every row
It works SUM(C1:G1) for one row
But I cannot copy that to 500 hundred rows quickly?
Merry Christmas
Harry |
|
| Back to top |
|
 |
AndrewZ
Moderator
Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA
|
| Posted: Sat Dec 24, 2005 4:16 pm Post subject: |
|
|
Actually C1:G1 is a relative reference, and if you copy and paste it down in K, it will sum C through G.
To make C1:G1 absolute (not relative), you would need to write $C$1:$G$1. |
|
| Back to top |
|
|
BookLady
Super User
Joined: 03 Nov 2004
Posts: 727
|
| Posted: Sat Dec 24, 2005 6:09 pm Post subject: |
|
|
To copy to 500 rows quickly
Put the formula in the first row of the column, click on the little handle in the lower right corner, drag to row 500 or what ever. Formula will fill down referencing each new row. This is pretty much the same as it was in XL.
Keyboard is: Put the formula in the first row, press shift and highlight that cell and holding shift scroll down the column all the way to the final cell wanted use Alt> Edit> Fill> Down that is AltE>i>d and the formula will fill to bottom referencing each new row.
Like ahz said use of the $ is the same as in XL and will keep the reference as typed not changing in each new cell. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sun Dec 25, 2005 10:19 am Post subject: Re: Relative Reference HELP |
|
|
| open.kinda.guy wrote: | I just want to sum colums C thru G into K on every row
It works SUM(C1:G1) for one row
But I cannot copy that to 500 hundred rows quickly?
|
There's always more than one way to swing a cat:
The sum is in H1? There is a small, square "handle" in the lower right of the cell with the cursor in it. As Booklady suggested, you can drag down, OR ...Drag down just a couple to select then, and they remain black, showing selection. Now scroll down to the required row, using the right scroll bar. Now choose Edit / Fill Selected.
David. |
|
| Back to top |
|
|
|
