formula question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i enter numbers from 42.33 - 50.00 using a formula rather than typing
all the numbers?
 
In what logical order?

By 1/100ths like 42.33, 42.34, 42.35

Enter 42.33 in A1

Enter 42.34 in A2

Select A1 then type A1:A768 in the namebox.

Hit Enter then Edit>Fill>Series>Autofill


Gord Dibben MS Excel MVP
 
yes by 1/100's. but i want it to go from a to p on each line (this is so it
all prints on the one page) is this possible? also what is the namebox?
 
As far as your second question is concerned, what did it tell you when you
typed namebox into Excel help?

For the first question, it might have been better if you'd given the full
details when you first asked the question.
Put 42.33 into A1, then in B1 put =A1+0.01 and copy across C1 to P1.
In A2 put =P1+0.01. Copy B1:P1 down to B2:P2. Copy A2:P2 down as far as
necessary.
 
Back
Top