Why Referencing Variable Cells Is a Better Option To overcome the drawbacks of hard-coding values in Microsoft Excel formulas, you could use cell references.