Cell References in Excel Formulas When you create a formula in an Excel cell, you'll frequently include a reference to another cell in the spreadsheet.

How Do I Reference a Cell in Another Worksheet in Excel?. Learning to use Excel worksheets like relational databases can help you save time, eliminating duplication when managing large projects.

You can use the formula [=A2*0.1] in cell B2 and drag the formula down the entire B column. Excel will automatically adjust the references to A3, A4, and so on.