Quick way to make Absolute Cell Reference across a table?

[Wolfspyda]

I'm just wondering if its possible to have a tables formula with an absolute cell reference?

I have a column that has the formula in starting Cell A3 as follows ='Hello'!A4.

This continues down the column from A3 to A2000. The last Formula reads ='Hello'!A2000.

this there a quick way to change the entire column to lock the Rows formula to read

='Hello'!A$4
='Hello'!A$5
='Hello'!A$6
...
='Hello'!A$2001

hopefully this makes sense.

If I highlight the 1st cell and fill down the ='Hello'!A$4, it continues down the list locked on ='Hello'!A$4. I have tried filling in 3 rows and then copying it down, but all it does is repeats the series in groups of 3. I tried to use the Fill series option but it seems to ignore the "$" command.

At present im going through the list individually. Im at cell A50 now (='Hello'!A$51). There has to be an easier way to do this than to manually go all the way to ='Hello'!A$2001

 

[AlphaFrog]

Select the column
Select from the menu the Edit\Replace function (Ctrl+H)
- Find what: A
- Replace with: A$
- Options\Look in:Formulas
- Replace All

 

[rlv01]

1. Select column
2. Do a search/replace (CTRL-H)
3. Search string = !A
4. Replace string =!A$

 

[Wolfspyda]

This was a brilliant idea and worked well. The next issue was to then add the "$" after the A in Columns from A to GR.

 

[rlv01]

If you do this kind of conversion a lot, consider a utility. I use this one

http://spreadsheetpage.com/index.php/pupv7/utilities/