Is there a way to insert the "$" to make a bunch of cells go from i.e. A4 to $A$4? There must be an easier way than to keep typing out the $'s!!
Thanks.
Is there a way to insert the "$" to make a bunch of cells go from i.e. A4 to $A$4? There must be an easier way than to keep typing out the $'s!! Thanks. 


This will take multiple steps, but you can do "Find and Replace" and replace "A" with "$A", "B" with "$B" and so on. I admit this is only a partial solution though. 


When entering a new formula, press F4 immediately after a cell reference to toggle between, for example, $A$1, A$1 and $A1 and A1. When editing an existing formula, press F4 when your cursor is at the start, end or inside a cell reference. 


A little VBA can do it (assuming you want all references set to absolute)



If you want to change If you want to change 


I was facing the same problem with a HUGE spreadsheet. Then, reading the posts here, I've found a very easy way to do that! In my specific case, I had an entire row of cells (4000+...) with a formula like I stopped looking for formulas or VBA tricks and started thinking on how Excel works. Then, I got a very helpful insight. What I did was.


