Fill Handle Will not work

%3CLINGO-SUB%20id%3D%22lingo-sub-1891974%22%20slang%3D%22en-US%22%3EFill%20Handle%20Will%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1891974%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20checked%20the%20Options%2C%26nbsp%3B%20Advanced%2C%26nbsp%3B%20Editing%20Options%2C%20to%20ensure%20'Enable%20fill%20handle%20and%20cell%20drag-and-drop'%20checkbox%20is%20selected.%26nbsp%3B%20%26nbsp%3B%20I%20have%20also%20made%20sure%20'Formula%20-%20Calculation%20Options'%20is%20set%20to%20Automatic.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20mouse%20pointer%20still%20will%20not%20change%20to%20a%20'move%20pointer'.%26nbsp%3B%20Therefore%2C%26nbsp%3B%20I%20am%20unable%20to%20use%20the%20Fill%20handle%20to%20copy%20a%20formula%20down%20a%20column.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20even%20unable%20to%20a%20value%20increment%2C%20for%20example%2C%26nbsp%3B%20%26nbsp%3B5%2C%206%2C%207%2C%208%2C%209%2010%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1891974%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1892225%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20Handle%20Will%20not%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1892225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F870791%22%20target%3D%22_blank%22%3E%40DawnBonl%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20screenshot%20the%20worksheet%20with%20the%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have checked the Options,  Advanced,  Editing Options, to ensure 'Enable fill handle and cell drag-and-drop' checkbox is selected.    I have also made sure 'Formula - Calculation Options' is set to Automatic.  

 

My mouse pointer still will not change to a 'move pointer'.  Therefore,  I am unable to use the Fill handle to copy a formula down a column.    

 

I am even unable to a value increment, for example,   5, 6, 7, 8, 9 10

1 Reply

@DawnBonl 

Can you screenshot the worksheet with the issue?