Hi all

I found I have a problem with AutoFill in Excel 2007. I have two
columns with the figures. Third colum includes calculation based on
the first two columns.
However, when I write the formula into first row and try to paste it
down using standard double click at the right bottom corner, there is
absolutely no action.

I found that also double click at the cell, which would move you to
the last record (double click at the bottom of the cell) or to the
first (double click at the top of the cell) does not work at all.

I checked the options (Excel Options / Advanced / Enable AutoComplete
as well as Enable fill handle and cell drag-and-drop) and it looks OK,
all these options are checked.
Any idea what is wrong?
Thanks a lot

Rgds
Pavel

Cannot replicate the problem unless there is a hidden or very skinny blank row
between source row and rest of data range.

Any chance of that?


Gord Dibben MS Excel MVP

On Sat, 16 Oct 2010 10:59:41 -0700 (PDT), slaya_cz <(E-Mail Removed)>
wrote:

>Hi all
>
>I found I have a problem with AutoFill in Excel 2007. I have two
>columns with the figures. Third colum includes calculation based on
>the first two columns.
>However, when I write the formula into first row and try to paste it
>down using standard double click at the right bottom corner, there is
>absolutely no action.
>
>I found that also double click at the cell, which would move you to
>the last record (double click at the bottom of the cell) or to the
>first (double click at the top of the cell) does not work at all.
>
>I checked the options (Excel Options / Advanced / Enable AutoComplete
>as well as Enable fill handle and cell drag-and-drop) and it looks OK,
>all these options are checked.
>Any idea what is wrong?
>Thanks a lot
>
>Rgds
>Pavel

On Oct 16, 2:21*pm, Gord Dibben <phnor...@shaw.ca> wrote:
> Cannot replicate the problem unless there is a hidden or very skinny blank row
> between source row and rest of data range.
>
> Any chance of that?
>
> Gord Dibben * * MS Excel MVP
>
> On Sat, 16 Oct 2010 10:59:41 -0700 (PDT), slaya_cz <pavel.mach...@gmail.com>
> wrote:
>
>
>
> >Hi all
>
> >I found I have a problem with AutoFill in Excel 2007. I have two
> >columns with the figures. Third colum includes calculation based on
> >the first two columns.
> >However, when I write the formula into first row and try to paste it
> >down using standard double click at the right bottom corner, there is
> >absolutely no action.
>
> >I found that also double click at the cell, which would move you to
> >the last record (double click at the bottom of the cell) or to the
> >first (double click at the top of the cell) does not work at all.
>
> >I checked the options (Excel Options / Advanced / Enable AutoComplete
> >as well as Enable fill handle and cell drag-and-drop) and it looks OK,
> >all these options are checked.
> >Any idea what is wrong?
> >Thanks a lot
>
> >Rgds
> >Pavel

Did you check to see that there was NOTHING in the cells below? I
just tried it in Excel 2007 and it stopped on a blank cell, but it had
a formula in it, just APPEARED blank. Just a possibility.

[adholam]

HIDE OR DISPLAY THE FILL HANDLE
By default, the fill handle is displayed, but you can hide it, or show it if it's hidden.

Click the Microsoft Office Button , and then click Excel Options.
Click Advanced, and then under Editing options, clear or select the Enable Fill handle and cell drag-and-drop check box to hide or show the fill handle.
To avoid replacing existing data when you drag the fill handle, make sure that the Alert before overwriting cells check box is selected. If you don't want to see a message about overwriting nonblank cells, you can clear this check box.
USE AUTO FILL OPTIONS TO CHANGE HOW THE SELECTION IS FILLED
After you drag the fill handle, the Auto Fill Options button appears so that you can change how the selection is filled. For example, you can choose to fill just cell formats by clicking Fill Formatting Only, or you can choose to fill just the contents of a cell by clicking Fill Without Formatting.