How to do it, step by step: 1. Type C2(=) 2. Select B11 3. Type ($) before the B and 11 ($B$11) 4. Type (*) 5. Select B2 6. Hit enter 7. Auto fill C2:C7 #Charts, Formulas and Functions in Excel 43