Ctrl+H is the only shortcut needed for mass formatting, data, and formula correction.
Gambling with cell references shouldn't be part of your workflow.