View original (French)

Mouse issue

litchoutsou Posted messages 86 Registration date   Status Member Last intervention   -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello everyone, I have a big problem with my mouse in Excel only.
I no longer have the pointer but a cross instead, and when I want to drag a formula down to the cells below, it's impossible; I have to copy and paste.
Is there a solution?

2 answers

  1.
    Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     
    Hello.

    For the cross, you should first check the mouse settings. But if this only happens with Excel, the problem is probably elsewhere ...
    Instead of copy-pasting,
    - to copy the content from cell A1 to cell A8,
    select A1:A8 and use the keyboard shortcut ctrl+B
    - to copy the content from cell A1 to cell A800,
    click on A1, scroll down to line 800, hold down the SHIFT key while clicking on A800, and then press ctrl+B
    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. LITCHOUTSOU
       
      Thank you, Raymond, for your quick response. In fact, to find my mouse, I had to go to advanced options, editing options, enable the fill handle and cell drag-and-drop. I had this problem after the Windows 10 update.
      1
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    in Options / Advanced options / Editing options you must have unchecked 'Cell dragging and dropping'.
    eric

    --
    By continuously trying, you eventually succeed.
    So the more it fails, the more chances you have that it works. (the Shadoks)
    In addition to the thank you (yes, yes, it happens!!!), remember to mark it as resolved. Thank you.
    0