With cell B2 selected, I can now use the fill handle in the bottom-right corner of the cell to duplicate this relative formula to the remaining rows of details.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.