Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I copy a function with a called cell constant?
I am using a function that references a remote cell value. I want to copy the
function to repeated cells, but have to edit each copied cell for the called cell location rather than its relative location. How do I refer to the cell, so that it is seen as the correct one for all copy locations? |
#2
|
|||
|
|||
Are you asking how to copy the formula so that the address of the remote cell
doesn't change? If so, convert it to an absolute reference address To make the column absolute, precede the column letter with a dollar sign ($), $a1 for instance To make the row absolute, precede the row # with a dollar sign - A$1 Use 2 dollar signs to make both absolute: $A$1 "MitchCarter1957" wrote: I am using a function that references a remote cell value. I want to copy the function to repeated cells, but have to edit each copied cell for the called cell location rather than its relative location. How do I refer to the cell, so that it is seen as the correct one for all copy locations? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
copy paste cell character limit | Excel Discussion (Misc queries) |