Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set one cell as a constant so I can drag the formula
I want to set, say, cell A1 with a number, say 10. I then want to reference
other cells back to the value 10. But when I drag the formula down successive cells no longer look at the value in A1, instead going to A2, A3, A4, etc.... I know this is easy to do, but I forget and can't word it right to find the answer using the help section in Excel. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set one cell as a constant so I can drag the formula
Make the cell reference "Absolute", instead of "Relative"...........
$A$1.......instead of A1 Vaya con Dios, Chuck, CABGx3 "juntipoikka" wrote in message ... I want to set, say, cell A1 with a number, say 10. I then want to reference other cells back to the value 10. But when I drag the formula down successive cells no longer look at the value in A1, instead going to A2, A3, A4, etc.... I know this is easy to do, but I forget and can't word it right to find the answer using the help section in Excel. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set one cell as a constant so I can drag the formula
Thanks mate - knew the $ was in there somewhere - d'oh!
"CLR" wrote: Make the cell reference "Absolute", instead of "Relative"........... $A$1.......instead of A1 Vaya con Dios, Chuck, CABGx3 "juntipoikka" wrote in message ... I want to set, say, cell A1 with a number, say 10. I then want to reference other cells back to the value 10. But when I drag the formula down successive cells no longer look at the value in A1, instead going to A2, A3, A4, etc.... I know this is easy to do, but I forget and can't word it right to find the answer using the help section in Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |