Change block of cell referances to absolute (F4)

eugene7

Board Regular
Joined
Apr 29, 2006
Messages
94
I have a large (very) range of cells that are presently referencing other cell values cells relatively - I need to convert them to absolute reference (the F4 command) but there are too many to do individually...

I tried to make a macro, but cant make it work.

The cells I need to change are in columns. Any ideas?

Steve
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Do all your releative formulas in one column, reference the same column ?
 

eugene7

Board Regular
Joined
Apr 29, 2006
Messages
94
Thanks for the free download suggestion, and yes they do all referance the same column from a single column...

Steve
 

Forum statistics

Threads
1,136,655
Messages
5,677,017
Members
419,668
Latest member
DharmaK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top