Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag a Named Formula
I have a named formula that references cells in the same row. Is there a way
to drag the named formula down so that it references the cells in the new row rather than keeping the references from the row it was named in? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drag a Named Formula
hi,
not sure what you mean by "drag" but if the formula does not have absolute references in it, you can copy the formula and paste it one row down or down the entire column. the formula will reference the cells in the row that it was pasted in. if the formula has absolute references in it, change them to relative references. relative reference = A1 absolute reference = $A$1 regards FSt1 "aynsley" wrote: I have a named formula that references cells in the same row. Is there a way to drag the named formula down so that it references the cells in the new row rather than keeping the references from the row it was named in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Cell just shows formula after named region var change | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions |