ExcelBanter - How to keep a cell ref in formula unchanged when the ref cell move

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to keep a cell ref in formula unchanged when the ref cell move (https://www.excelbanter.com/excel-discussion-misc-queries/77191-how-keep-cell-ref-formula-unchanged-when-ref-cell-move.html)

Clifton Ford

How to keep a cell ref in formula unchanged when the ref cell move

If a formula in one cell references, for example, cell C1, how can I keep the
formula refering to cell C1 when cell C1 moves to another cell by inserting
or dragging.

Ron Coderre

How to keep a cell ref in formula unchanged when the ref cell move

Instead of =C1, try:

=INDIRECT("C1")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Clifton Ford" wrote:

If a formula in one cell references, for example, cell C1, how can I keep the
formula refering to cell C1 when cell C1 moves to another cell by inserting
or dragging.

Clifton Ford

How to keep a cell ref in formula unchanged when the ref cell

Yes, thanks much

"Ron Coderre" wrote:

Instead of =C1, try:

=INDIRECT("C1")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

"Clifton Ford" wrote:

If a formula in one cell references, for example, cell C1, how can I keep the
formula refering to cell C1 when cell C1 moves to another cell by inserting
or dragging.

All times are GMT +1. The time now is 03:46 AM.