Crosshair is missing when I try to click & drag a cell

[maureen]

All of the sudden the black crosshair went away in Excel. I still get the
white cross, but when I hover in the bottom right corner to click and drag
the cell down, it doesn't show up anymore. I can't highlight a section and
move it either.

Does anyone know how to get this feature back?

Thanks for your help!

[Jim Thomlinson]

Tools -> Options... | Edit tab | Check Allow Drag and Drop
--
HTH...

Jim Thomlinson

[Jacob Skaria]

If you are using XL 2007; then review the 3rd option under

Office Button>Excel Options>Advanced>'Enable fill handle and cell
drag-and-drop'

If this post helps click Yes
---------------
Jacob Skaria

[mhmd...@gmail.com]

thanks

[mimi...@gmail.com]

Fantastic! Thank you - my problem is now solved because of your post!

[af.ge...@gmail.com]

Very Useful. It resolved my issue. Thank you very much

[rgay...@gmail.com]

This happens regularly to me. Every week or so it reverts to the state where i am unable to drag formulas across the cells. Do you know why this occurs?

Thanks

[nara...@gmail.com]

Still works! :-) Thanks.

[sdesale...@gmail.com]

Yes
it is working
thanks

[Issa Ali]

Many Thanks

[Rick O'Gorman]

The most likely issues is you need to change the zoom. The black cross then will appear. I was at 120%, changed to 110% and the cross appeared for two columns, but not two others. I then zoomed to 100% and it worked for the others. See https://superuser.com/questions/1481984/dragging-the-fill-handle-in-microsoft-excel-white-gloved-hand-shows-up-instead-o