A cell reference in a formula changing

K

knemitz

How do I keep a cell reference in a formula from changing when a cell is
inserted above it?
 
B

Bernie Deitrick

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
 

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

Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0
Is there a function to count how many times a cells value is used? 0
Autonumber field in Excel that behaves the same as Access 0
Converting a number into a cell reference 2
Excel help needed: Skipping cell without skipping cell reference 1
External cell reference between two excel worksheets both in One Drive 0
Cells not updated automatically 3

Top