title: Autofill not working as expected in Excel
body: <p>I'm using Excel 2003 and I'm trying to autofill a basic formula but it's not working properly for me.</p>
  
  <p><img src="https://i.stack.imgur.com/C1H4G.jpg" alt="enter image description here"></p>
  
  <p>The formula I'm trying to drag accross takes the value in B2 and adds it to the previous cells value. So the value in F10 is E10+B2 etc. I entered it manually for the first 7 cells and then when I try and drag it accross it starts to reference cells C2, D2, E2 etc. when it should just stay B2. </p>
  
  <p>It does this even though I highlighted a group of previous cells where B2 clearly remains the same.</p>
  
  <p>How to get around this?</p>