How do I change a cell from absolute reference to relative referen

G

Guest

I want to change in an existing worksheet a particular cell that looks to me
like it has an absolute reference. I want to make it so the data can be
changed in the cell, so I assume that would be a relative reference. When I
try and make the change it does not let me, and the cell is not locked, nor
the worksheet. Thank you
 
N

Niek Otten

What is your formula? In which cell? What are the values of the cells you
are trying to process? What result did you expect? What did you get instead?
What do you mean by "does not let me"?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

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

Change a cell reference from relative to absolute 2
Absolute and Relative Cell References 1
advanced relative cell reference 1
Relative worksheet reference clarified 4
Change relative to absolute references in a block of cells 3
A "relative" absolute cell reference? 6
Copying formulas, relative and absolute cell references 3
How do I copy a combobox to many cells with relative reference? 1

Top