| View previous topic :: View next topic |
| Author |
Message |
fatgreta
Power User
Joined: 12 Feb 2004
Posts: 80
|
 Posted: Wed Oct 01, 2008 7:28 am Post subject: Copy / Paste Question |
 |
|
Hi,
I have a row of cells, B11 - B49. In cells C11 - C49, I want to calculate the percentage of each cell compared to the total in cell B6. So for cell B11 I write =B11/B6, and that works fine. I want to then be able to copy and paste that into the cells C12-C49, so that it reads =B12/B6; =B13/B6, etc. When I use copy and paste, though, it fills in the value as =B12/B7; =B13/B8, etc. I now there used to be a way to do this in excel, many years ago at least. Is there a way to do it with OO? I've tried every available option in Paste Special, but none of them seem to work.
Thanks,
Chris |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8995
Location: Lexinton, Kentucky, USA
|
| Posted: Wed Oct 01, 2008 8:55 am Post subject: |
|
|
| =C11/B$6 |
|
| Back to top |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands
|
| Posted: Wed Oct 01, 2008 8:59 am Post subject: Re: Copy / Paste Question |
|
|
| fatgreta wrote: | | So for cell B11 I write =B11/B6, and that works fine. |
Add two dollar-signs, one before the B of B6 an one in front of the 6 of B6, so that code reads:
This makes B6 to be an ABSOLUTE reference.
.Now you can, with the small handle in the bottom right corner of cell C11, drag that formula down as far as you want.
| fatgreta wrote: | | , so that it reads , etc. When I use copy and paste, though, it fills in the value as =B12/B7; =B13/B8, etc. |
This will make that the above cells now read:
| Code: | | =B12/$B$6; =B13/$B$6, =B14/$B$6 and so on |
and will always refer to cell B6
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
fatgreta
Power User
Joined: 12 Feb 2004
Posts: 80
|
| Posted: Wed Oct 01, 2008 9:01 am Post subject: |
|
|
Outstanding! Thanks so much.
Chris |
|
| Back to top |
|
|
DiGro
Super User
Joined: 02 Jun 2004
Posts: 1210
Location: Hoorn NH, The Netherlands
|
| Posted: Wed Oct 01, 2008 9:03 am Post subject: |
|
|
that's about one of the shortest answers ever I think. 
However, absolute correct.
Now it is clear to me how you beat me to this one John 
_________________
DiGro
Windows 7 Home Premium and OOo 3.3 NL (Dutch) |
|
| Back to top |
|
|
|
|
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
|
