Fixed cell reference

C

Carla

I am trying to have a cell reflect what is in a specific
cell (i.e. C5) even if I decide to insert a column or row
before it. It will automatically change the cell
reference. Is there anyway to tell it no matter what I
do, always tell me what is in C5?

You are all great helpers, keep up the great work!
Carla
 

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

Insert Row - Stop Automatic Formula Update 1
Last Modified By in a cell by user 3
cell reference in sumifs 4
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Get cell reference address 2
Selecting a diff. worksheet but same cell references using Validat 1
Vlookup increment No 4
How to reference or redirect a formula in a base row? 3

Top