If you have this formula:Is there a way I can change a selection of cells from a mixed reference to an absolute reference? In other words if cells A1..K100 start as A$1..K$100; how can I get them to be $A$1..$K$100?
See reply #3 by Excel MVP Gord Dibben in this thread:Don't think that applies here (or at least I don't see it). Let me explain further.
Let's say in worksheet 'Daily' I reference data from worksheet 'Data' which is actually a CSV file. So in my 'Daily' worksheet cell A5 reads... ='Data.csv'!A1 then I copy cell A5 to columns B thru K (row 1). Then I can copy row 1 to 2 thru 100. When done is there a way I can select those cells (A1:K100) and change them all at once to an absolute reference?