Mouse issue
litchoutsou
Posted messages
86
Registration date
Status
Membre
Last intervention
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur 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?
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 réponses
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)
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)
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.
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.
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.