SOLVED
Home

Fill data automatically in worksheet cells does not work anymore

%3CLINGO-SUB%20id%3D%22lingo-sub-359782%22%20slang%3D%22en-US%22%3EFill%20data%20automatically%20in%20worksheet%20cells%20does%20not%20work%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359782%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ethank%20you%20for%20reading.%20I%20have%20a%20problem%20with%20my%20excel%20program%20and%20was%20not%20found%20a%20solution%20with%20google%3A%20Filling%20data%20automatically%20in%20worksheet%20cells%20does%20not%20work%20anymore.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20reboot%20my%20system%20(win%207%2C%2064-bit)%2C%20then%20start%20excel%20(MS%20Office%20Prof.%20Plus%202013)%20with%20an%20empty%20worksheet%20(no%20filters%2C%20etc.).%20Then%20I%20am%20typing%201%2C2%2C3%2C4%20into%20cells%20A1%20to%20A4%20and%20select%20those%204%20cells.%20Normaly%2C%20when%20I%20move%20my%20mouse%20pointer%20down%20to%20the%20right%20edge%20of%20selected%20cells%2C%20the%20pointer%20changes%20to%20a%20'plus'%20sign.%20But%20this%20does%20not%20happen%20anymore%20and%20therefore%20it%20is%20not%20possible%20to%20click%20the%20edge%20and%20expand%20the%20selected%20cells%20and%26nbsp%3Bfilling%20data%20automatically%20(1%2C2%2C3%2C4%2C5%2C6%2C7%2C8%2C9%2C...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20the%20other%20hand%2C%20I%20can%20not%20move%20the%20selected%20cells%2C%20by%20draging%20the%20edge%20of%20the%20selected%20cells%20to%20an%20other%20position.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20similar%20problems%3F%20How%20can%20I%20repair%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHans.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359782%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360465%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20data%20automatically%20in%20worksheet%20cells%20does%20not%20work%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360465%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hans%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20think%20that%20there%20is%20a%20keyboard%20shortcut%20to%20change%20this%20option.%3C%2FP%3E%3CP%3EIt%20might%20be%20changed%20because%20of%20a%20bug%2C%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Eaccidental%20error%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%20macro%20code%2C%20or%20third-party%20add-in.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360303%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20data%20automatically%20in%20worksheet%20cells%20does%20not%20work%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360303%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CSPAN%3EHaytham%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ethat%20was%20the%20solution.%20Thank%20you%20very%20much%20for%20that%20hint.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAnyway%2C%20I%20don't%20unterstand%20how%20this%20option%20could%20be%20changed.%20Maybe%20a%20shortcut%20key%20combo%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHans.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359921%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20data%20automatically%20in%20worksheet%20cells%20does%20not%20work%20anymore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359921%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hans%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20go%20to%20the%20Excel%20Options%20and%20make%20sure%20that%20the%20below%20option%20is%20enabled.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F84993i5E084CF52BAF232C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Enable%20fill%20handle%20and%20cell%20drag-and-drop.png%22%20title%3D%22Enable%20fill%20handle%20and%20cell%20drag-and-drop.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EHaytham%3C%2FP%3E%3C%2FLINGO-BODY%3E
HansGermany
New Contributor

Dear all,

thank you for reading. I have a problem with my excel program and was not found a solution with google: Filling data automatically in worksheet cells does not work anymore.

 

I reboot my system (win 7, 64-bit), then start excel (MS Office Prof. Plus 2013) with an empty worksheet (no filters, etc.). Then I am typing 1,2,3,4 into cells A1 to A4 and select those 4 cells. Normaly, when I move my mouse pointer down to the right edge of selected cells, the pointer changes to a 'plus' sign. But this does not happen anymore and therefore it is not possible to click the edge and expand the selected cells and filling data automatically (1,2,3,4,5,6,7,8,9,...)

 

On the other hand, I can not move the selected cells, by draging the edge of the selected cells to an other position.

 

Does anyone have similar problems? How can I repair this?

 

Regards,

Hans.

 

3 Replies
Solution

Hi Hans,

 

Please go to the Excel Options and make sure that the below option is enabled.

Enable fill handle and cell drag-and-drop.png

 

 

Hope that help

 

Regards,

Haytham

Hello Haytham,

 

that was the solution. Thank you very much for that hint.

 

Anyway, I don't unterstand how this option could be changed. Maybe a shortcut key combo?

 

Thank you 

Hans.

Hi Hans,

 

I don't think that there is a keyboard shortcut to change this option.

It might be changed because of a bug, accidental error, macro code, or third-party add-in.

 

Best Regards

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies