fixing formula references in bulk

J

jasman

Board Regular
Joined
Oct 30, 2010
Messages
141
Hi. I have a load of cells which contain formula referencing cells from another workbook. Is there a way to fix the cell references all in one go instead of putting a $ in each formula one by one?

thanks
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Can you show some examples of the formulas, and what you want to change them to?
 
Upvote 0
I think I've seen something around this issue on the board somewhere. Might be worth more of an in depth search. Pretty sure it involves VB.
 
Upvote 0
You must log in or register to reply here.

Similar threads

datatronics505
  • Solved
Absolute reference to a cell of another table
Replies
5
Views
211
datatronics505
datatronics505
B
  • Question Question
Creating dynamic Sum range if total is at the top of range
Replies
2
Views
192
Peter_SSs
Peter_SSs
P
  • Question Question
TypeScript (or other solutions) for modifying given list of cells (and similar problems)
Replies
0
Views
256
Pingaware
P
R
  • Question Question
Excel Database and Dependant Lists
Replies
7
Views
267
felixstraube
F
D
  • Question Question
I need to reference sheets with names that are dates, but cannot get formula to work!
Replies
3
Views
177
RoryA
RoryA

Forum statistics

Threads
1,224,602
Messages
6,179,841
Members
452,948
Latest member
UsmanAli786

Share this page

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
Back
Top