Dragging and not incrementing issue

[topswim]

I am not sure why I am not able to perform this now. I have the number in cell A1 as 532248950201317 and want to drag so cell A2 will increment to 532248950201318, cell A3 to 532248950201319, etc. What is happening is when I drag A1 it is not incrementing as thought it would. A2 still remains as 532248950201317. This is MS Office 2007 that I am usig and know I did not have this issue a little ways back when I wanted to do this. I appreciate any answer and thank you in advance. This should of been a simple operation to perform.

Topswim

 

[RoryA]

You can hold down the Ctrl key as you drag to switch the Fill/Copy functionality from whatever it is doing by default.

 

[la_bond]

if you are using a filter on your data make sure all your rows are visible when you are dragging down