That did it. Thanks. There are so many hidden tricks that either are not documented or well hidden.
"Johnny.1966" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Here is what I do: > > When I drag down, I keep the Ctrl key pressed. Very easy and works fine > for me. > > > Johnny > > > > Den 2006-01-12 18:45:27 skrev The Morses <[EMAIL PROTECTED]>: > >> At 04:31 AM 1/12/2006, you wrote: >>> Dennis Marks wrote: >>> >>>> When a number is entered into a cell and then dragged the numbers >>>> increase by 1. How can I turn this feature off? >>> >>> Never searched for it. >>> What you can do: copy the cel, select other cels, and paste. >>> >>> Succes, >>> Cor >> >> >> The feature is AutoFill, but it sounds like you're trying to enter a >> single value all the way down. It's simple and I use it >> all the time, just enter the desired value ie; 5 in the first three >> or four cells in the column. Highlight those cells and you'll >> see a small black box in the lower right corner of those highlighted >> cells. Grab it with the mouse and drag it down and >> you'll have a column of "5's". >> >> Good Hunting. >> >> PS, this works with pretty much any PATTERN you enter in the first >> few cells, ie; odd numbers, dates, etc..... OOo is >> pretty intuitive here. >> >> >> >> ========================== >> Don Morse / www.blackpalace.com >> ICQ 245937 / AIM merlinof2 >> [EMAIL PROTECTED] >> ========================== >> ========================== >> Don Morse / www.blackpalace.com >> ICQ 245937 / AIM merlinof2 >> [EMAIL PROTECTED] >> ========================== >> >> --------------------------------------------------------------------- >> 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]
