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.
Bookmarks