Enter 5 in A1 and A2, select A1:A2, click and drag from the lower right corner to A20. Now the values A1 to A20 are 5 in every one of them.
However there is a way to do this without having to enter the value in more than one cell:
Example: 1. Enter your date in A1 2. Press and hold the Ctrl key. 3. Click the lower right corner of A1 and drag down. Works perfect, at least for me with OOo 1.1.4.
Johnny
-----Original Message----- From: Carl Paulsen [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 5:00 PM To: [email protected] Subject: [users] Auto fill
OO 1.1.4, Win XP
I have a spreadsheet with a date that I want to be able to drag to auto fill a single date over a range of records/rows. I've been able to do this in several other spreadsheets as follows: type in at least 2 values for the same date (2 rows will have, for instance, 4/9/2005). Then I select these two dates, click the lower right corner of this selection, and drag the selection for the entire range of rows I want to
fill with that same date. When I do this in other spreadsheets, the software assumes that since the two dates are the same, the rest should be the same too. When I do this in OO, what I get is the original two values, followed by two rows of the next date, followed by 2 rows of the
subsequent date, etc., as follows:
4/9/05 4/9/05 4/10/05 4/10/05 4/11/05 4/11/05 4/12/05 4/12/05 etc.
If I type in 3 rows with the same date and do this kind of auto-fill, I get the same pattern with three rows of consecutive dates. I can see where this kind of auto-fill could be very handy, but what I want is just 12 rows of one date, 4/9/05. It seems like the user should establish a pattern which the auto-fill takes over for the range specified. I seem to be missing how OO works, and I couldn't find a setting to do what I want. Also checked the archives but didn't find anything.
BTW, I'm a long-time Mac user so I'm a mouse user with a hard habit and I prefer the drag and drop approach, but I suppose I could change... Also, I mostly LOVE the OO software so far!
Thanks Carl
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
