Hello:
I have a large number of formulas that I'm trying to add absolute references to without going into each cell one by one.
I've been able to highlight a range in a column and do a find/replace for each column but have +100 columns to do...
Is there an easier way to do this?
=IF(A12=0,"","Sheet1"!C12) change to =IF(A12=0,"",'Sheet1!$C$12)
Thanks.
Drew
Assuming the relative reference (A12=0) is correct, change the C12 to absolute ($C$12), copy and paste the corrected formula into the desired columns/cells.
Originally Posted by shg
You could select all the columns (Using the Cntrl key to add new columns if they are not side by side), then use find/replace and 'replace all'
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi Changing
Is a lot easier. Is that Ok?
=IF(A12=0,"","Sheet1"!C12) change to =IF($A$12=0,"",'Sheet1!$C$12)
This is the first part of the solution.
It will convert any appearances of cell number like C12 to $C$12.
The next stage is to convert R[1]:C[1] formats
Original formula
In the formula bar select the full formula using mouse.=DSUM(A3:B8,B3,A1:A2)
Press F4 key All your reference will be absolute
Press F4 Again You will get=DSUM($A$3:$B$8,$B$3,$A$1:$A$2)
Press F4 Again You will get=DSUM(A$3:B$8,B$3,A$1:A$2)
=DSUM($A3:$B8,$B3,$A1:$A2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks