Just thinking - you may have calculation set to manual. Go to
ToolsOptionsCalculation then make sure the "Automatic" button is selected.

"GEM" wrote:

I am trying to filter information I have on a worksheet and then adding
numbers to a column right next to the info and dragging it down to have 1, 2,
3, etc. It turns all the numbers I dragged down to 1. Why??