How to set default text in auto fill options in Microsoft Excel

[Kaesav]

When I use excel to do registration, I enter customers address and want to click and pull down that address into cells below, but when I do the address number increases in value. I can go into auto fill options and change it, but I want it to always select copy cell and default back to it. On this spread sheet. I have some columns that default to copy cells and other columns that when I try to drag a number it increases in value because it defaults to fill series. How do i change this.

[Bontu]

When you select a single cell that contains a number, then drag the Fill Handle, the default behavior is to copy. When the cell contains a date, or text with a number at the end of a portion of the text (e.g. 123 Main Street), the default is to fill the series. To override either behavior, press the Ctrl key as you drag the Fill Handle. Release the mouse button, then release Ctrl key. (Note: you can press the Ctrl button at any time during the AutoFill process, so if you start to drag, and the autofill isn't doing what you want, press the Ctrl key.)

[Essien]

There is a another simple thing that you can try out. Right-click on the cell fill handle, drag and release then select "Copy Cells" or "Fill Series".