Formula Techniques

• To copy a large number of formulas without changing relative references:

  • Edit, Replace "=" with "#" before copying;

  • Copy and paste;

  • Edit, Replace "#" with "=".

• Ctrl + "~" toggles between displaying formulas and calculated values