Formatting options missing after dragging cell value
<p>I have two worksheets in my workbook.</p>

<p>On worksheet A, when I drag a value to other cells a smart tag displays with three options:</p>

<ul>
<li>Copy Cells</li>
<li>Fill Formatting Only</li>
<li>Fill Without Formatting</li>
</ul>

<p>On worksheet B, when I drag a value to other cells a smart tag displays with one option:</p>

<ul>
<li>Copy Cells</li>
</ul>

<p>Any idea what I have done to change the behaviour? It's driving me insane..</p>