I can't autofill and move cells

%3CLINGO-SUB%20id%3D%22lingo-sub-935050%22%20slang%3D%22en-US%22%3EI%20can't%20autofill%20and%20move%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-935050%22%20slang%3D%22en-US%22%3E%3CP%3ESuddenly%20I%20can't%20autofill%20and%20move%20cells.%3C%2FP%3E%3CP%3EMy%20cursor%20stays%20a%20white%20cross.%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3CP%3EElle%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-935050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-935634%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20autofill%20and%20move%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-935634%22%20slang%3D%22en-US%22%3EWhen%20things%20lock-up%20like%20that%2C%20it%20can%20sometimes%20be%20resolved%20by%20using%20the%20%22esc%22%20key.%20Or%20closing%20the%20file%20and%20re-opening.%20Or%20rebooting%20the%20computer.%20In%20that%20order.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20no%20resolution%2C%20please%20attach%20a%20copy%20of%20your%20spreadsheet%20so%20we%20can%20see%20the%20problem%20in%20action.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-936300%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20autofill%20and%20move%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-936300%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20very%20much%20for%20your%20reply.%3C%2FP%3E%3CP%3EI%20was%20able%20to%20resolve%20it%20by%20assessing%20the%20Help%20menu%20for%20Excel.%3C%2FP%3E%3CP%3EI%20went%20to%20File%20Options%20Advanced%20and%20fixed%20the%20autofill%20there.%3C%2FP%3E%3CP%3E%22Somehow%22%20it%20got%20unchecked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Suddenly I can't autofill and move cells.

My cursor stays a white cross.

Please help!

Elle

2 Replies
When things lock-up like that, it can sometimes be resolved by using the "esc" key. Or closing the file and re-opening. Or rebooting the computer. In that order.

If no resolution, please attach a copy of your spreadsheet so we can see the problem in action.

@mathetes 

thank you very much for your reply.

I was able to resolve it by assessing the Help menu for Excel.

I went to File Options Advanced and fixed the autofill there.

"Somehow" it got unchecked.