Forum Discussion
Copying without refreshing references
Hello, I'd like to copy a formula in a cell to another cell without refreshing references, I mean, exactly the same formula en other location. I know that i can move the formula with "CtrlX" but...
Thank you Hans,
The absolute reference is a good point however I can't use it because I'd like to drag the formula to other cell from the new position so I need to conserve it with no dollars.
Copying the formula from the formula bar is the option that I'm using right now but I was wondering if an automatic process without cutting exists.
Thank you so much for your response!
The absolute reference is a good point however I can't use it because I'd like to drag the formula to other cell from the new position so I need to conserve it with no dollars.
Copying the formula from the formula bar is the option that I'm using right now but I was wondering if an automatic process without cutting exists.
Thank you so much for your response!
I'm not aware of another built-in way to do what you want.
A VBA macro would be another possibility, but that is probably overkill.