How to put the '$' into numerous list at once

Hi this must sound very silly but is there aneasier way to put the $ into a list of formulas than do it manually? I have from B6 dragged down to B100 that all now have to change to $B$6 to $B$100, its going to take me ages!

Attached lists in A abd B must all get $

Thanks!

Find and replace should do it.

Find: B
Replace: $B$

Give it a go!

Mind you, dragging 100 rows probably takes the same number of seconds as doing the F&R ...

By the way, your thread title is too generic - make titles more descriptive in future, please.

Based on the workbook you have now provided (tested):

1. Select column B.
2. Find: STOCKTAKE'!A
3. Replace: STOCKTAKE'!$A$

Did you see post #3?

1. Select column B so that it is completely highlighted (click on the column header).
2. With column B highlighted, click on Find & Select > Replace ... on the Home ribbon (far right).
3. In the Find box type: STOCKTAKE'!A
4. In the Replace box type: STOCKTAKE'!$A$
5. Hit Replace All (button bottom left).

Been there, got the T-shirt!

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.