Technique For Same cell reference Across Many Cells:
This may be a dumb question, but I don't know how it's done.
When I need to copy a part of a formula that references the same cell, yet do so across many cells, and I use copy/paste, the formula cell reference changes with the paste.
Cell A1 has a value
Cell B1 =D1*A1
Cell B2 =D2*A1
Cell B3 =D3*A1
If I cut and paste B1 to B2 to B3, etc., the formula will automatically change to:
B2 = D2*A2
B3 = D3*A3
How do I keep a constant for A1 throughout all the cells, without having to go back by hand and changing every cell to the correct A1 reference? It's not too bad if I'm do 20 or 30 references, but if it's a row with hundreds of references, this is too cumbersome.
Thank you! EDR