Change selected cells to absolute reference

[Mogogo]

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?

 

[T. Valko]

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?

If you have this formula:

=SUM(A1:K1)

In the formula bar, highlight the range references then repeatedly hit function key F4 until you get the reference style you want then hit Enter.

 

[Mogogo]

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?

 

[T. Valko]

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?

See reply #3 by Excel MVP Gord Dibben in this thread:

http://tinyurl.com/4vt6r47

 

[Mogogo]

Worked perfect. Thank you, T. Valko.
One follow up question though. If the source cell is blank I get a #ref in my destination cells. Is there anyway I can eliminate this and just show a blank?