OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Relative Reference HELP

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
open.kinda.guy
Newbie
Newbie


Joined: 24 Dec 2005
Posts: 1

PostPosted: Sat Dec 24, 2005 4:03 pm    Post subject: Relative Reference HELP Reply with quote

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
View user's profile Send private message AIM Address Yahoo Messenger
AndrewZ
Moderator
Moderator


Joined: 21 Jun 2004
Posts: 4140
Location: Colorado, USA

PostPosted: Sat Dec 24, 2005 4:16 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
BookLady
Super User
Super User


Joined: 03 Nov 2004
Posts: 727

PostPosted: Sat Dec 24, 2005 6:09 pm    Post subject: Reply with quote

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
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Sun Dec 25, 2005 10:19 am    Post subject: Re: Relative Reference HELP Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group