Absolute to relative references (Excel 2003)

Topic

New Reply

Is there a way to change cell references from absolute to relative (or vice versa) on multiple cells at once. As an oversimplified example, I would like to be able to highlight a series of cells and hit the F4 key. I want to avoid having to go into each formula individually to make the change. All of the formulas are referencing external workbooks.

Reply | Quote

Replies

See post 173133 for some code

Steve

Reply | Quote

See post 173133 for some code

Steve

Reply | Quote

Hi,

ASAP Utilities is a free addin and does this as well as a heap of other stuff, check it out at:

http://www.asap-utilities.com

Good Luck!

Peter Moran

Reply | Quote

The ASAP Utility is amazing. It works perfectly changing a block of cell formulas from relative to absolute (including multiple references within a formula). I am looking forward to checking out the other features.

Thanks Peter

Reply | Quote

The ASAP Utility is amazing. It works perfectly changing a block of cell formulas from relative to absolute (including multiple references within a formula). I am looking forward to checking out the other features.

Thanks Peter

Reply | Quote

Hi,

ASAP Utilities is a free addin and does this as well as a heap of other stuff, check it out at:

http://www.asap-utilities.com

Good Luck!

Peter Moran

Reply | Quote