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
Best Response confirmed by Sebastian Schmidt (New Contributor)
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