Hi Ivan,
If you enter .06 in one cell, then select it and several below it you
can use 'edit / fill / series' with .01 in the increment box to get what
you want. Once you have some cells with the series, if they're still
selected, doing an auto-fill by dragging the handle on the last cell
will continue the series. I'm using v2.0, so I can't say if you'll get
the same results. Edit / fill will work for sure.
tc
Ivan Paganini wrote:
Sorry if the question was to uncertain. This was the exact what I needed: a
linear series starting with 0.06 and going to 0.2 with increments of 0.01,
say. Doing what you told me did not work: or it fills all the rows with 0.06,
or alternates (when ctrl pressed) 0.06 and 0.08. I will try a little more
and sees what happens. Is there another way? Maybe the linear series in edit
-> fill that you were talking about.
Thanks
Ivan
On 11/3/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
If you want the values to increment by a certain value, other than 1, you
need to enter the first two values. For example, enter 0.06 in A1, then
0.08 in
A2. Then select both A1 and A2, and use the fill handle to drag down. This
will create a series where the increments between numbers are 0.02.
If that's not what you're after, can you be more specific with your
question?
In a message dated 11/3/2005 8:45:57 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
But I need to fill with floating points: to 0.06 to 0.2, say.
--
-----------------------------------------------------------
Ivan S. P. Marin
Laboratório de Física Computacional
lfc.ifsc.usp.br <http://lfc.ifsc.usp.br>
Instituto de Física de São Carlos - USP
----------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
