Inserting $ symbol into multiple cells

[Butters190]

Hey All,

This may have been already answered but any help would be appreciated. My current issue is that I need to enter a $ into multiple formulas before cell numbers without having to do it manually, is there a way to do this? I cannot drag the cell across with the $ already entered as this will change the cell reference in an adjacent cell.

If this is not clear, what my scenario is that I have a 250 x 2500 cell table. Going across the x axis the formula is: J2-AVERAGE(J$2:J$11) then the next cell K2-AVERAGE(K$2:K$11) and so on. I now want a $ to appear before J and K without having to manually insert $ into every formula, so that I can drag the columns down varying the column number. Is there a simple way of doing this or am I going to have to tough it out?

Cheers

[AliGW]

have you tried find and replace?

Find: K

Replace with: $K

Very quick for each column of formulae.

[Butters190]

It was my first point of call. This will work however is still very time consuming as you have to find and replace each column as the letter changes as you go across the excel sheet. If you could do find all the different cell references and change them to $"all cell references" in one go this would be a solution.

[AliGW]

I think you're out of luck. Find and replace is the closest you are going to get, I think, however you did not say that you had already tried it.

[Butters190]

Ah OK. Yeah it seemed like a bit of a long shot. Thanks for your help!

[newdoverman]

If the formulae are in a column and the columns in the formulae are incremented evenly as they are dragged across the worksheet, select the first column where the formula is and do the Find and Replace as described by AliGW then drag the new formula across. All the changes will be made.

The same goes for formulae in rows but drag down.