Selecting a cell in Excel goes to an incorrect cell

Hi @LesemannCPA,

Thank you for posting your question in the Microsoft Q&A forum.

According to your concern, this issue is not a global problem with Excel, but it is usually caused by a mismatch setting or an add-in effect. Therefore, I suggest you can try these workarounds to narrow down the situation first:

1- Open Excel safe mode    

• Press Windows + R to open Run dialog box and type excel /safe > press OK to run.   

• If Excel works normally, the problem is due to an add-in.    
• Then and go to File > Options > Add-ins > select Excel Add-ins > Go > uncheck all listed add-ins and click OK. Repeat the same steps with the COM add-ins 

• Restart Excel and check if the error is gone. Then re-enable the add-ins one by one and restarting Excel each time to find which one causing the error. 

2- Repair Office   

• Go to Control Panel > Programs > Programs and Features.  
• Find Microsoft Office, right-click, and choose Change.   
• Select Quick Repair. If that doesn’t work, try Online Repair.   

Please understand that my initial response may not always resolve the issue immediately. However, you can try these steps and let me know if it works for you. If not, we can work together to resolve this.  

If you have any questions or need further assistance, please feel free to share them in the comments so I can continue to support you.  

Thank you for your patience and your understanding. I look forward to your response. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

The behavior where selecting a cell highlights the wrong or multiple adjacent cells is typically caused by how selection is being made, or by worksheet protection.

To work around and control cell selection reliably in Excel:

1. To select a single cell
   • Click once on the cell.
2. To select a range of adjacent cells
   • Click the first cell, then hold the left mouse button and drag over the other cells, or
   • Click the first cell, then hold Shift and use the arrow keys to extend the selection.
3. To select non-adjacent cells or ranges
   • Hold Ctrl while clicking each cell or range that needs to be selected.
4. To select entire rows or columns
   • Click the column letter at the top to select the whole column, or click any cell in the column and press Ctrl+Space.
   • Click the row number on the left to select the whole row, or click any cell in the row and press Shift+Space.
   • To select non-adjacent rows or columns, hold Ctrl while clicking the row numbers or column letters.
5. To select a whole list, table, or worksheet
   • Click any cell in the list or table and press Ctrl+A to select the list/table.
   • Click the Select All button at the top-left corner of the sheet (above row 1 and left of column A) to select the entire worksheet.
6. If selecting one cell highlights multiple adjacent cells
   • This can be a known selection issue. For tips on resolving it, see the community post linked from the article: “How do I stop Excel from highlighting two cells at once?”
7. If the sheet is protected
   • On a protected worksheet, some cells may not be selectable or editable at all. In that case, unprotecting the sheet or adjusting which cells are locked is required before selection/editing will behave as expected.

For persistent or complex selection problems beyond these behaviors, using the Excel Tech Community or Excel Forum on Answers is recommended to share specific details (version, device, steps, screenshots) so engineers and support agents can investigate and provide targeted fixes or workarounds.

References:

• Select cell contents in Excel
• Can’t edit certain cells in a protected worksheet in Excel for Mac
• Autofilter drop-down issue when cells exceeds 10000 in Excel for Office 365
• How to resolve the Microsoft Query could not be started error in Excel
• Excel may stop or close when using new IME in Windows 11