Cell references in formulas

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

Guest

Greetings,
Normally when I insert rows above a formula, the cell reference in the given
formula will change based on the inserted rows. However I have a particular
worksheet where this doesn't happen and I have to manually change the cell
reference in the formulas to include the new inserted cells. Do you have any
idea why this is so and what I can do about it? Thank you.
 
If the inserted row is right above a range which is used in your formula,
Excel doesn't know if it has to be included in the range.
One technique often used is to make the range one row higher than needed,
but empty (check the effect on your formulas!); insertion are then done
after that first row and the range in the formula will be extended.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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

Cell Reference & formula 5
Copying formulas, relative and absolute cell references 3
Hyperlink via indirect cell reference 8
Excel VBA 1
Automatically copy formulas in selected row into a new row? 3
Invalid References in formula 3
Formula help 1
Cell references within formulae 1

Back
Top