[SOLVED] Rows Missing but not Hidden?

I was trying to auto-fill a column with numbers like

Please Login or Register  to view this content.

you know, simple drag and release. So I started off with

Please Login or Register  to view this content.

then dragged and ended up with

Please Login or Register  to view this content.

From what I can gather, having cleared contents in case of false blanks etc, the issue arises because the rows aren't sequential. Row numbers are as follows:

Please Login or Register  to view this content.

Where the " - "represent a thicker separator line than normal.
However there is no hidden line

Any suggestions on how to fix this so I can drag down the list? I have about 2,000 entries to give codes to.

Thanks

Hi,

Do any row numbers appear in blue font? If so, there is a filter applied to the data.