Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


share|improve this question

Make it into three columns.

Make a nominator column, and a denominator column. Then make a column with the formula.

1  3  =1/3
1  4  =1/4
1  5  =1/5
1  6  =1/6
1  7  =1/7

If it's not a regular interval it excel won't be able to intuit the pattern.

share|improve this answer
I must be particlarly thick today. 1 in a1 3 in b1 and what exactly in c1? – Auto Aug 3 '10 at 2:14
@Auto in C1: =A1/B1 – box9 Aug 3 '10 at 3:06
+1 to dtang. Format c1 as a fraction in "format cells" (CTRL+1) and it'll work. I tested it. – JNK Aug 3 '10 at 10:30
Forgot to thank... my bad. So, THANK YOU! – Auto Oct 28 '10 at 23:34
@Auto - Happy to help. If it worked for you, please accept the answer. – JNK Oct 29 '10 at 2:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.