+ Reply to Thread
Results 1 to 3 of 3

Set default in auto fill options, I always want to copy cell, som.

  1. #1
    OSHAman
    Guest

    Set default in auto fill options, I always want to copy cell, som.

    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 colums that default to copy cells and other colums that
    when I try to drag a number it increases in value because it defaults to fill
    series. How do i change this?

  2. #2
    Debra Dalgleish
    Guest

    Re: Set default in auto fill options, I always want to copy cell,som.

    When you select a single cell that contains a number, then drag the Fill
    Handle, the default behaviour 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 behaviour, 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.)

    OSHAman wrote:
    > 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 colums that default to copy cells and other colums that
    > when I try to drag a number it increases in value because it defaults to fill
    > series. How do i change this?



    --
    Debra Dalgleish
    Excel FAQ, Tips & Book List
    http://www.contextures.com/tiptech.html


  3. #3
    Gord Dibben
    Guest

    Re: Set default in auto fill options, I always want to copy cell, som.

    Alternate method...

    Right-click on the cell fill handle, drag and release then select "Copy Cells"
    or "Fill Series".


    Gord Dibben Excel MVP

    On Fri, 25 Mar 2005 08:26:55 -0500, Debra Dalgleish <dsd@contexturesXSPAM.com>
    wrote:

    >When you select a single cell that contains a number, then drag the Fill
    >Handle, the default behaviour 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 behaviour, 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.)
    >
    >OSHAman wrote:
    >> 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 colums that default to copy cells and other colums that
    >> when I try to drag a number it increases in value because it defaults to fill
    >> series. How do i change this?



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1