Using the Wrong Cell Reference Many Excel users don't understand cell references in Excel. You have a relative reference (e.g., =A1), which changes the row and column based on the cell it's copied to.