excel filter not working extra rows appearing

When you apply a filter to showhide rows youll notice that the row numbers in the filter range change to blue text. So I get roun…