A common scenario for me is I'll copy a formula and use it in a new sheet. Often (as in the img) the formula will reference the same cell over and over. In this case it is cell BF7. When I first pasted the formula in there, those four occurrences were pointing to AX7. What is the easiest way to change all for of those at once? I know that I can do "find-n-replace." If there were 20 occurrences, I would have done that. For this example, I merely drag-n-dropped the little colored square from AX7 to BF7, four times (once for each color).

I think I remember reading somewhere about a keyboard combo that will drag all the colored squares from one location to the other in one drag. Do you guys know how to do this?