SOLVED

Excel cursor not changing; fill handle not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2252513%22%20slang%3D%22en-US%22%3EExcel%20cursor%20not%20changing%3B%20fill%20handle%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252513%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20new%20HP%20Elitebook%20laptop%20running%20Windows%2010%20pro%20with%20Office%20365%20that%20I%20downloaded%20last%20week.%20OS%20and%20Office%20are%20up%20to%20date.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20working%20on%20a%20huge%20analysis%20that%20I%20do%20every%20month%20and%20my%20cursor%20is%20acting%20really%20bizarre%20in%20Excel.%20The%20fill%20handle%20isn't%20working%3B%20when%20I%20click%20by%20the%20header%20of%20a%20column%2C%20the%20down%20arrow%20doesn't%20appear%3B%20I%20can't%20adjust%20column%20widths%3B%20it's%20very%20hard%20to%20select%20a%20whole%20row%20by%20clicking%20the%20numbers%20along%20the%20left%20side%20(keeps%20wanting%20to%20change%20row%20height%20unless%20I%20expand%20the%20row%20and%20then%20do%20it...)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20idea%20what's%20going%20on%20here%3F%20I'm%20super-frustrated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20checked%20the%20Options%2C%20Advanced%2C%20Editing%20Options%2C%20to%20ensure%20'Enable%20fill%20handle%20and%20cell%20drag-and-drop'%20checkbox%20is%20selected.%20I%20have%20also%20made%20sure%20'Formula%20-%20Calculation%20Options'%20is%20set%20to%20Automatic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20mouse%20pointer%20still%20will%20not%20change%20to%20a%20'move%20pointer'.%20Therefore%2C%20I%20am%20unable%20to%20use%20the%20Fill%20handle%20to%20copy%20a%20formula%20down%20a%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20checked%20that%20the%20spreadsheet%20is%20at%20100%25%2C%20so%20scaling%20shouldn't%20be%20an%20issue...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20help!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2252513%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2257008%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cursor%20not%20changing%3B%20fill%20handle%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257008%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1016368%22%20target%3D%22_blank%22%3E%40donna140%3C%2FA%3E%26nbsp%3BHi%20Donna.%20I%20was%20having%20the%20same%20issue%2C%20and%20oddly%20enough%20disconnecting%20my%20docking%20station%20from%20its%20power%20supply%20and%20re-plugging%20it%20back%20in%20fixed%20it%20for%20me.%20If%20you%20are%20using%20a%20docking%20station%20I%20would%20recommend%20trying%20that.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2257033%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cursor%20not%20changing%3B%20fill%20handle%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2257033%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1018502%22%20target%3D%22_blank%22%3E%40Smartin92%3C%2FA%3EThanks%20so%20much%20for%20your%20response.%20I%20actually%20did%20that%20on%20Sunday%20(as%20a%20total%20last%20resort)%20and%20it%20worked!%20Really%20appreciate%20your%20response.%20This%20was%20an%20incredibly%20frustrating%20experience.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2332168%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cursor%20not%20changing%3B%20fill%20handle%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2332168%22%20slang%3D%22en-US%22%3EI%20just%20wanted%20to%20thank%20you%20for%20this!%20I%20have%20spent%20far-too-long%20trying%20to%20work%20out%20how%20to%20fix%20the%20exact%20same%20problem.%20So%2C%20following%20you%20advice%2C%20I%20unplugged%20everything%20from%20everything%20and%20then%20plugged%20it%20all%20back%20in!%20Et%20voil%C3%A0%3A%20the%20problem%20is%20fixed!!!!%20You%20have%20saved%20me%20a%20LOT%20of%20time!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2567367%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cursor%20not%20changing%3B%20fill%20handle%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2567367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1018502%22%20target%3D%22_blank%22%3E%40Smartin92%3C%2FA%3E%26nbsp%3BOk%2C%20I%20thought%20it%20was%20crazy%20to%20just%20detach%20my%20keyboard%20from%20my%20surface%20tablet.%20I%20tried%20a%20hundred%20ways%20to%20get%20my%20curser%20back.%20Your%20simple%20trick%20worked.%20Thank%20You%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2687886%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cursor%20not%20changing%3B%20fill%20handle%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2687886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1108299%22%20target%3D%22_blank%22%3E%40LeighSeal%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20am%20so%20impressed%20and%20thankful%20I%20had%20to%20comment.%20I%20too%20work%20with%20large%20spreadsheets%2C%20i%20dropped%20my%20mouse%20and%20although%20not%20broken%20was%20having%20the%20same%20issues%20that%20were%20really%20starting%20to%20impact%20my%20work.%20I%20had%20previously%20tried%20everything%20restarting%2C%20reloading%20drivers%20etc.%20I%20kept%20searching%20for%20answers%20then%20came%20across%20this%20post%20fixed!%20Many%20thanks%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a new HP Elitebook laptop running Windows 10 pro with Office 365 that I downloaded last week. OS and Office are up to date.

 

I'm working on a huge analysis that I do every month and my cursor is acting really bizarre in Excel. The fill handle isn't working; when I click by the header of a column, the down arrow doesn't appear; I can't adjust column widths; it's very hard to select a whole row by clicking the numbers along the left side (keeps wanting to change row height unless I expand the row and then do it...)

 

Does anyone have any idea what's going on here? I'm super-frustrated!

 

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've checked that the spreadsheet is at 100%, so scaling shouldn't be an issue...

 

please help!!

5 Replies
best response confirmed by donna140 (New Contributor)
Solution

@donna140 Hi Donna. I was having the same issue, and oddly enough disconnecting my docking station from its power supply and re-plugging it back in fixed it for me. If you are using a docking station I would recommend trying that. 

@Smartin92Thanks so much for your response. I actually did that on Sunday (as a total last resort) and it worked! Really appreciate your response. This was an incredibly frustrating experience.

I just wanted to thank you for this! I have spent far-too-long trying to work out how to fix the exact same problem. So, following you advice, I unplugged everything from everything and then plugged it all back in! Et voilà: the problem is fixed!!!! You have saved me a LOT of time!

@Smartin92 Ok, I thought it was crazy to just detach my keyboard from my surface tablet. I tried a hundred ways to get my curser back. Your simple trick worked. Thank You

@LeighSeal

I am so impressed and thankful I had to comment. I too work with large spreadsheets, i dropped my mouse and although not broken was having the same issues that were really starting to impact my work. I had previously tried everything restarting, reloading drivers etc. I kept searching for answers then came across this post fixed! Many thanks