Hi Suzie,

Another way is to put numbers 1 to 10 (i.e. 1 in A1, 2 in A2 etc.) in a
blank column then copy them down to the end of your data and then
use autofilter to select every tenth row.

HTH
Martin