A cell reference in a formula changing

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

Guest

How do I keep a cell reference in a formula from changing when a cell is
inserted above it?
 
You need to use the INDIRECT worksheet function. For example, to refer to
cell A1 no matter what is inserted above or to the left of the current cell
A1:

=INDIRECT("A1")

HTH,
Bernie
MS Excel MVP
 
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
insert blank row and formulas 1
Move cell and maintain reference 4
Filling formulas with specific cell references remaining the same 1
AutoFill Changing Wrong Value 6
Calculate the position of a formula and number of cells from it 2
Automatic update to SUM formula cell references. 6
Formulas That Reference ADJACENT Sheet 4

Back
Top