mouse marca campo errado em ctrlC ctrlV ou procv pulando celulas

Question

excel não aceita marcação de área para ctrlC ctrlV ou procv. arrasta dados não solicitados e altera comandos

Answer 1

Hello Dolar. You may be having a problem with Excel not selecting the right cells with your mouse. This kind of behavior is sometimes associated with zoom settings, display scaling settings, and/or bug issues with the interface of Microsoft 365. A few users have noted the problem occurred more often when they were working on multiple monitors, freeze panes, and or grouped rows. One temporary solution is to reset the zoom to 100 or toggle between views (like from Page Layout to Normal view), before trying to work again which may allow the cursor to realign with the correct cell. There are also other users who reported success, by turning off hardware graphics acceleration from Excel's Advanced Options, or they opened Excel in Safe Mode to rule out add-in conflicts. If the problem persists across different work books and devices, we may suggest reporting directly in Excel's feedback tool to enable Microsoft to prioritize a fix.

Here's the reference: Excel selects wrong cell Cursor Selecting Wrong Cell in Excel

Note: I am providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Best regards,

Answer 2

Hello Dolar. It seems you're having an annoying problem with copy-pasting (Ctrl+C, Ctrl+V), especially when trying to use PROCV (VLOOKUP). You may be having a problem with Excel not selecting the right cells with your mouse. This kind of behavior is sometimes associated with zoom settings, display scaling settings, and/or bug issues with the interface of Microsoft 365. A few users have noted the problem occurred more often when they were working on multiple monitors, freeze panes, and/or grouped rows. One temporary solution is to reset the zoom to 100% or toggle between views (like from Page Layout to Normal view), before trying to work again which may allow the cursor to realign with the correct cell. There are also other users who reported success, by turning off hardware graphics acceleration from Excel's Advanced Options, or they opened Excel in Safe Mode to rule out add-in conflicts. If the problem persists across different work books and devices, we may suggest reporting directly in Excel's feedback tool to enable Microsoft to prioritize a fix.

Here's the reference: Excel selects wrong cell Cursor Selecting Wrong Cell in Excel

Note: I am providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Best regards,