How to copy an unreferenced cell and keep the formula
Hi,
I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and pasting or referencing the cell ? Thanks, Tom |
How to copy an unreferenced cell and keep the formula
tomfabtastic,
in the formula "=G6", "G6" is the reference to another cell........a "Relative" reference to another cell. In order to adjust this formula so it will not change when you copy it to a new cell, you need to make it "Absolute". Just use dollar signs to do that: Chage: =G6 to: =$G$6 A reference can be completely relative: G6 Completely absolute: $G$6 or a mix of both absolute and relative: G$6 (column will change when copying, but row won't) $G6 (row will change, but column won't) HTH, Conan wrote in message ... Hi, I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and pasting or referencing the cell ? Thanks, Tom |
How to copy an unreferenced cell and keep the formula
Hi Tom, try adding the ' $' sign at the beginning of G, such as =$G9.
" wrote: Hi, I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and pasting or referencing the cell ? Thanks, Tom |
How to copy an unreferenced cell and keep the formula
Maybe =$G$6 will do.
Gord Dibben MS Excel MVP On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote: Hi, I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and pasting or referencing the cell ? Thanks, Tom |
How to copy an unreferenced cell and keep the formula
On Nov 29, 11:25 am, Gord Dibben <gorddibbATshawDOTca wrote:
Maybe =$G$6 will do. Gord Dibben MS Excel MVP On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote: Hi, I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and pasting or referencing the cell ? Thanks, Tom- Hide quoted text - - Show quoted text - Thanks for the suggestions. But is there an alternative to using the $- signs and making the cell refence absolute ? Tom |
How to copy an unreferenced cell and keep the formula
You could use Insert/ Name/ Define to define a name for your G6 cell, and
then use that name in your formula. -- David Biddulph wrote in message ... Thanks for the suggestions. But is there an alternative to using the $- signs and making the cell refence absolute ? On Nov 29, 11:25 am, Gord Dibben <gorddibbATshawDOTca wrote: Maybe =$G$6 will do. Gord Dibben MS Excel MVP On Wed, 28 Nov 2007 15:55:29 -0800 (PST), wrote: Hi, I have a formula in a cell, say, =G6. How can I copy this formula to another cell. At present, when I copy the formula changes because it is not referenced. When I copy, paste special with formulas the formula still moves. Anyone have a solution without cutting and pasting or referencing the cell ? Thanks, Tom |
All times are GMT +1. The time now is 09:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com