[Fixed!] Cursor Selecting Wrong Cell in Excel (6 Proven Solutions)

Here are the Quarterly Sales Data for 2021 shown in the B4:F14 cells, containing the Location and the four Quarters Q1, Q2, Q3, and Q4, respectively. We want to fix the issue of the Excel cursor selecting the wrong cell.

excel cursor selecting wrong cell


Solution 1 – Checking Whether the Extend Selection Feature Is Enabled

With the Extend Selection feature, you might inadvertently select other cells alongside your intended one.

Checking Whether the Extend Selection Feature Is Enabled or Not

Steps:

  • Check the Status Bar to see if Extend Selection is visible.
  • Press the F8 key or the Esc key to turn off Extend Selection. The status should disappear from the Status Bar.

Turning off Extend Selection

  • This disables the Extend Selection feature.

Fixing excel cursor selecting wrong cell by disabling Extend Selection


Solution 2 – Adjusting the Zoom Percentage

Steps:

  • Move to the View tab and click Zoom.

Adjusting the Zoom

  • Choose a magnification according to your preference and hit the OK button.

Applying Custom Zoom

You can also adjust the zoom using the Zoom Slider in the Status Bar.

Fixing excel cursor selecting wrong cell by changing zoom


Solution 3 – Opening Excel in Safe Mode

Steps:

  • Close Excel.
  • Click the Windows button and find excel from the app list.
  • Hold down the Ctrl key and left-click to open Excel.

Opening Excel in Safe Mode

  • A message appears asking if you want to open Excel in Safe Mode.
  • Choose Yes.

Fixing excel cursor selecting wrong cell by opening excel in Safe Mode


Solution 4 – Disabling All Add-ins

Steps:

  • Navigate to the File tab at the top-left corner.

Disabling All Add-ins

  • Click the Options button at the bottom.

Moving to Excel Options

  • The Excel Options wizard will appear.
  • Go to the Add-ins section.
  • In the Manage field, choose the COM Add-ins option and click on Go.

Removing COM Add-ins

  • Uncheck all the Add-ins and press OK.
  • Restart Excel.

Fixing excel cursor selecting wrong cell by disabling add ins


Solution 5 – Enabling Direct Editing in Cell

In the screenshot below, Double-clicking the C17 cell prompts the cursor to jump to the C9:F9 cell since it’s using that data to compute the value. Fortunately, there is a simple workaround.

Enabling Direct Editing in Cell

Steps:

  • Go to the File tab.

Selecting File tab

  • Select the Options section.

  • Navigate to the Advanced tab.
  • Check Allow editing directly in cells.
  • Press OK button.
  • Restart Excel.

Fixing excel cursor selecting wrong cell by enabling direct cell editing


Solution 6 – Changing the Page Layout

Steps:

  • Go to the View tab and choose the Normal view.

Changing Page Layout

If the problem persists, consult Microsoft Support’s website.


What to Do If Cursor Is in the Wrong Place in Excel?

Steps:

  • Go to the File tab.

What to Do If Excel Cursor Is in the Wrong Place

  • Choose Options to open the settings window.

  • Select the Advanced tab.
  • In the Display section.
  • Check the Disable hardware graphics acceleration option and press OK.

Fixing excel cursor selecting wrong cell by disabling hardware graphics acceleration

You might need to update your Office version to fix this feature.


Download Practice Workbook


Related Articles


<< Go Back to Cursor in Excel | Excel Parts | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

2 Comments
  1. I have an HP Spectre running on office 365 and its driving me crazy that after a few minutes of working on a spreadsheet the mouse clicking and cells that are chosen is off by 5 or 6 cells.
    I tried these suggested fixes but it did not address my problem.
    What works temporarily is to shut down the working file, closing Excel and re-starting again excel with the same file.
    Is it Office 365?
    Is it my HP Spectre 360?
    Is it Windows 11?
    All of the software is confirmed to be up to date

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Mar 28, 2024 at 1:23 PM

      Hello Larry

      Thanks for sharing your problem. Being remote makes it difficult to provide an ultimate solution. However, you can try Repairing Office Installation, Checking Graphics Card Drivers, and Checking for Conflicting Add-ins.

      Sometimes, a corrupted Office installation can cause unexpected behavior. To fix this, you can try repairing your Office 365 installation. Outdated or incompatible graphics card drivers could also contribute to display issues. Update your graphics card drivers to the latest version from HP’s website.

      If none of the above solutions work, you might need to contact HP Support for further assistance. Though the exact cause (Office 365, HP Spectre, or Windows 11) remains unclear, hopefully, you can try these ideas to overcome your situation.

      Regards
      ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo