I'm trying to fill a range with fractions i.e. 1/3, 1/5, 1/7, 1/9 etc. When i try to drag the fill handle down it gives me all kinds of odd results. e.g.1/8, 1/5, 2/7 etc. Any ideas on how to get Excel to just continue the series?
Thanks!
I'm trying to fill a range with fractions i.e. 1/3, 1/5, 1/7, 1/9 etc. When i try to drag the fill handle down it gives me all kinds of odd results. e.g.1/8, 1/5, 2/7 etc. Any ideas on how to get Excel to just continue the series? Thanks! 


Make it into three columns. Make a nominator column, and a denominator column. Then make a column with the formula.
If it's not a regular interval it excel won't be able to intuit the pattern. 

