title: How do I stop Excel applying styles from previous rows into subsequent rows?
body: <p>I have an issue with Excel where when I paste some formatted cells in, some subsequent rows inherit the style from above. This is unwanted behaviour and I can't seem to stop Excel from doing this. Does anyone know how to stop this behaviour?</p>
  
  <p>To explain further, in the image below you can see cells A1-A5 have a formatting of a grey background and bold text. If I copy cells A1-A5 and paste them into a new workbook, if I type into cells A6, A7 or A8 then the style (grey background and bold) is automatically applied. If I type into cell A9 then this style is not applied.</p>
  
  <p><a href="https://i.stack.imgur.com/79Qht.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/79Qht.png" alt="enter image description here"></a>  </p>
  
  <p>What is going on?  </p>
  
  <p>This only happens when I <strong>paste</strong> into a new workbook. It doesn't happen if I was to apply the style to cells in an open workbook.</p>
  
  <p><strong>Steps to reproduce</strong></p>
  
  <ol>
  <li>Create a new spreadsheet</li>
  <li>In cells A1 to A5, put the letters 1 to 5</li>
  <li>Format cells A1 to A5 and make the background light grey and the font bold.</li>
  <li>Select Cells A1 to A5 and copy them.</li>
  <li>Create a new workbook</li>
  <li>In the new workbook, go to cell A1 and press CTRL-V to paste.</li>
  <li>Move to cell A9 and type anything. It will be in normal style</li>
  <li>Move to cell A8 and type anything. It will have the same style as the cells A1-A5</li>
  </ol>
  
  <p>Why is Excel doing this and how can I make it stop doing it?</p>
  
  <p>I am using Excel version 14.0.7153.5000 (32-bit) on Windows 10.</p>