Locking Cells

Robin Penfold · Mar 30th, 2004, 06:43 PM

Hello. I've made a spreadsheet that has an area for entering data. It then has a number of different cells that feed off this data with simple formulas like =A1 etc. However if I then copy some of the original data, or move it, then the =A1 cell will update itself to follow where the data has moved to.

How can I lock the cell, or the formula, so that whatever I do with the data, it will always feed from A1?

Cheers,
Robin

bolo · Mar 30th, 2004, 06:47 PM

Add dollar signs: $A$1.

Read up about absolute references in the help.

HTH

DRJ · Mar 30th, 2004, 06:51 PM

absolute references still update if the referenced cell is moved.

Mar 30th, 2004, 06:43 PM	#1
Robin Penfold Join Date: Mar 2004 Posts: 8	Locking Cells Hello. I've made a spreadsheet that has an area for entering data. It then has a number of different cells that feed off this data with simple formulas like =A1 etc. However if I then copy some of the original data, or move it, then the =A1 cell will update itself to follow where the data has moved to. How can I lock the cell, or the formula, so that whatever I do with the data, it will always feed from A1? Cheers, Robin

Mar 30th, 2004, 06:47 PM	#2
bolo Join Date: Mar 2002 Posts: 292	Re: Locking Cells Add dollar signs: $A$1. Read up about absolute references in the help. HTH

Mar 30th, 2004, 06:51 PM	#3
DRJ MrExcel MVP Join Date: Feb 2002 Location: California Posts: 3,857	absolute references still update if the referenced cell is moved. __________________ Excel VBA Training and Certification (Lesson 1 is free) <hr> <hr>-Jacob

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode