Excel is a deep product if you're willing to get a bit technical. Some tips for developers on using Excel. Relative vs. absolute references – When you copy and paste a reference, Excel will translate that reference to the new coordinates (relative reference). To keep the reference the same when it's moved, use absolute references. Denoted by a