SOLVED

Excel Problem with the Auto Fill Option

%3CLINGO-SUB%20id%3D%22lingo-sub-278325%22%20slang%3D%22en-US%22%3EExcel%20Problem%20with%20the%20Auto%20Fill%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278325%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20Problem%20with%20the%20Auto%20fill%20Option.%3C%2FP%3E%3CP%3EI%20want%20to%20complete%20a%20multiplication.%3C%2FP%3E%3CP%3EFor%20Example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20Column%20A%20*10%3C%2FP%3E%3CP%3EFormel%3A%20%3DA1*10%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Problem%20is%20that%20only%20the%20first%20row%20is%20correct.%20The%20following%20are%20wrong.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20a%20lot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20524px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F58322iA9697B4A9B27A0A0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Unbenannt.PNG%22%20title%3D%22Unbenannt.PNG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Problem%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291186%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%20with%20the%20Auto%20Fill%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291186%22%20slang%3D%22en-US%22%3EMy%20autofill%20works%20in%20the%20rows%20but%20not%20in%20the%20columns.%20I%20tried%20F9%20and%20it%20didn't%20do%20anything.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278535%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%20with%20the%20Auto%20Fill%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278535%22%20slang%3D%22en-US%22%3EYou%20are%20a%20genius.%20%3DD%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20know%20why%20but%20the%20Auto%20calculation%20was%20on%20manual.%3CBR%20%2F%3EThanks%20a%20lot.%20%3DD%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278508%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%20with%20the%20Auto%20Fill%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278508%22%20slang%3D%22en-US%22%3E%3CP%3EMay%20be%20silly%2C%20but%20do%20you%20have%20auto%20calc%20turned%20off%3F%26nbsp%3B%20Press%20F9%20to%20see%20if%20you%20calcs%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278487%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%20Problem%20with%20the%20Auto%20Fill%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278487%22%20slang%3D%22en-US%22%3EHey%20Sebastian%2C%20Try%20manually%20filling%20in%203-4%20of%20the%20cells%2C%20then%20do%20autofill.%20In%20my%20experience%20when%20autofill%20gets%20something%20wrong%20it%20is%20typically%20because%20i%20have%20not%20supplied%20enough%20data.%20So%20if%20you%20are%20trying%20to%20multiple%20them%20all%20by%2010%2C%20then%20make%20c-2%2C%2020%2C%20c-3%2030%2C%20c-4%2040%2C%20then%20try%20the%20autofill%20again.%20Adam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-552837%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Problem%20with%20the%20Auto%20Fill%20Option%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F234574%22%20target%3D%22_blank%22%3E%40Sebastian%20Schmidt%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20auto%20fill%20is%20not%20working....%20checked%20Options-advance%20and%20that%20checks%20out...%20tried%20F9%20as%20the%20response%20suggested%20but%20that%20didn't%20do%20anything%20at%20all.....%20I%20am%20sure%20the%20functionality%20is%20turned%20off%20somehow%2C%20but%20not%20sure%20what%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMatt%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello,

I have a Problem with the Auto fill Option.

I want to complete a multiplication.

For Example:

  Column A *10

Formel: =A1*10

 

The Problem is that only the first row is correct. The following are wrong. 

 

Thank you a lot.

 

Unbenannt.PNG 

5 Replies
Highlighted
Hey Sebastian, Try manually filling in 3-4 of the cells, then do autofill. In my experience when autofill gets something wrong it is typically because i have not supplied enough data. So if you are trying to multiple them all by 10, then make c-2, 20, c-3 30, c-4 40, then try the autofill again. Adam
Highlighted
Solution

May be silly, but do you have auto calc turned off?  Press F9 to see if you calcs work.

Highlighted
You are a genius. =D

I don't know why but the Auto calculation was on manual.
Thanks a lot. =D
Highlighted
My autofill works in the rows but not in the columns. I tried F9 and it didn't do anything.
Highlighted

@Sebastian Schmidt 

Hi,

 

My auto fill is not working.... checked Options-advance and that checks out... tried F9 as the response suggested but that didn't do anything at all..... I am sure the functionality is turned off somehow, but not sure what to do.

 

Matt