Top Post: Perhaps there is a macro that would do this? Maybe Andrew or someone else with knowledge in this area might have some suggestions.
Dan On Tuesday 16 August 2005 01:51 pm, Addison wrote: > Thanks for the reply Dan. > > I am aware of that mouse drag feature. However I have RSI arm pain > when using the computer so I prefer using the keyboard which is > easier on my arms than a mouse is. In the Word Perfect Quattro Pro > spreadsheet program, you can just do a <ctrl-shift-L> to > automatically fill in a series (without any pop-up dialog). I was > hoping for the same functionality in Open Office, but it looks like > it's not possible to avoid that dialog when using the keyboard. > > "Dan Lewis" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > On Monday 15 August 2005 05:57 pm, Addison wrote: > >> In the spreadsheet, when I go to the menu "Edit > Fill > Series", > >> a dialog pops up showing the different "fill series" options. Is > >> it possible to configure it so that the dialog does not come up? I > >> always just use the default options so the dialog is not > >> necessary. > >> > >> Thanks in advance for your help. > > > > The answer is no considering how you are doing it. The program > > has no way of knowing what you want to do when you "Edit > Fill > > > Series." There is a simple way of filling in a series without > > getting this dialog. Enter enough of the series to establish the > > pattern you want and highlight all of those cells. At the bottom > > right of these highlighted cells will be a handle (a little square > > box). Drag the handle in the direction you want the series to go: > > to the right for a row or down for a column. The rest of your > > series will be filled in to the point you stop draging. > > > > Dan > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
