Drag a Named Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locking a cell reference in a formula 1
drag a formula downa column keeping one value the same? 2
Excel Drag autofill only part of formula 3
INDIRECT function to reference a named range 2
Dependent drop down dynamic range formula, off sheet. 7
drag formula down from columns that go acros 3
using the =page! feature to transpose a row to column 0
How do I increment the row and column of a cell in a formula? 2

Back
Top