Tom Woodford
New Member
- Joined
- Dec 14, 2013
- Messages
- 10
IDK what you call them but I use the $ sign in formulas all the time to lock the value of cell called out in a formula so that it does not change when I copy and past to a new location, so if you have an entire column or row of values that you want to change the $ signs in all at the same time how do you do that?
I have been guilty of changing these one at a time and it is very time consuming and tedious
I have been guilty of changing these one at a time and it is very time consuming and tedious