Absolute Cell References for large amount of cells??

Hi there,

I want to link a number of cells on one worksheet back to another worksheet within the same workbook. Say everything from Cells A1 to M90.

I find the fastest way to do this link A1 on second worksheet to A1 on first worksheet (by using = and click on worksheet 1 Cell A1).
I then click on cell A1 on worksheet 2, grab small square in bottom right hand side of cell, and drag accross to M1.
While A1 TO M1 is still highlighted, I then grab small square on bottom of cell M1 and drag down to M90.

This makes all cells within this range reference back to worksheet1. In advanced settings I have unchecked for all blank cells to show a zero in woksheet 2.

Therefore I now have what I currently want, although I would like to make all reference absolute??
I tried doing this from the beginning again making A1 absolute at the start, but dragging the cells across and down does not provide the info I am looking for in all cells??

Is there a way for me to do this??

Thanks in advance.

So, you have formulae like this:

=Sheet1!A1

One way to change them is to apply Find & Replace several times. Highlight columns A to M, then CTRL-H to bring up the F&R dialogue box and fill in the following:

Find what: !A
Replace with: !$A$
Click Replace all

With the dialogue box still visible, change !A to !B and !$A$ to !$B$ and click Replace All, and continue up to M.

Hope this helps.

Pete