Gambling with cell references shouldn't be part of your workflow.
Excel's built-in formatting tools are designed to make life easier.