The autofill function of Excel seems to be damaged.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 12 Jul 2006 03:24 GMT

Dear Sir,
    The autofill function of Excel seems to be damaged. The following figures
showed what happened when I use autofill function with my PC.

    When I click the cell with the wrong result, I found that the function is
correct but the number is wrong as following figure shows.

    After I double click the cell with the wrong result, I will enter the edit
mode for the cell. I just press enter, the cell will show the right result
then as following figure shows.

    This is really strange. Please help me to solve it. Contact me if necessary.

Reply to this Message

Gord Dibben - 12 Jul 2006 04:28 GMT

Jonathan

Your pictures did not come through.

Just type out some examples of your data and what it does or doesn't do.

If entering formulas, sounds like your cells have been formatted as text.

Copy an empty cell formatted as General.

Select your data and, in place, Paste Special>Add>OK>Esc

Just a guess but I'm rounding up the usual suspects.

Gord Dibben MS Excel MVP

>Dear Sir,
> The autofill function of Excel seems to be damaged. The following figures
[quoted text clipped - 9 lines]
>
> This is really strange. Please help me to solve it. Contact me if necessary.

Reply to this Message