Excel Performance Problems

Fix Excel Selecting the Wrong Cell at Custom Zoom Levels

Khadija Khan Sep 25, 2026 868 views

Question details

Users report that Excel selects an incorrect, adjacent cell or row when clicking on a specific cell, particularly when the zoom level is set to 50% or 80%.

How to Fix Excel Selecting the Wrong Cell at Non-100% Zoom

Product: Microsoft Excel (Desktop and Web)
Device & OS: Windows, Microsoft Edge
Scenario: Clicking to edit or format specific cells while working on a spreadsheet with a customized zoom level.
Observed behavior: The application highlights and selects a different cell or row instead of the one the user actually clicked with their mouse cursor.

Before you start

Ensure you save your current spreadsheet progress. As a quick diagnostic check, verify if the selection issue disappears immediately when you reset your view to exactly 100% zoom.

Solution 1Recommended

Reset Zoom to 100% and Update Software

The most effective temporary workaround is to reset the zoom to 100% and ensure your Office installation and system drivers are fully up to date.

This cell selection glitch is often tied to a bug in how Excel renders its grid at fractional zoom levels on certain display setups. Keeping the zoom at 100% prevents the misalignment.

Microsoft frequently releases patches for these types of display anomalies, so updating your software is highly recommended.

Reset Excel Zoom

Click the 'View' tab on the top ribbon and click the '100%' button, or drag the zoom slider at the bottom right corner of the Excel window to exactly 100%.

Update Microsoft Office

Navigate to File > Account > Update Options and select 'Update Now' to download the latest bug fixes.

Update Windows and Graphics Drivers

Open Windows Settings, go to 'Windows Update', and check for updates to ensure your OS and display drivers are current.

Report the Issue: If the problem persists after updating, use the Help > Feedback option in Excel to report the bug to Microsoft, including your Excel and OS version numbers.

Solution 2

Troubleshoot Excel for the Web Selection Issues

If you are experiencing this selection bug in the web version of Excel (such as in Microsoft Edge), clearing browser data or trying an alternative browser can isolate the problem.

Free Microsoft Office alternative

Switch to WPS Office for a Stable Spreadsheet Experience

If Microsoft Excel continues to struggle with zoom and cell selection bugs, consider switching to WPS Office. It is a free, lightweight alternative that offers robust spreadsheet capabilities without frustrating display glitches.

1. Download and Install: Get the free WPS Office installer from the official website and run it on your PC.
2. Open WPS Spreadsheets: Launch the WPS Office suite and click on the 'Spreadsheets' module.
3. Edit Your Excel Files: Click 'Open' and select your existing .xlsx file to continue working with flawless zooming and navigation.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formatsReliable and accurate cell selection at any zoom levelLightweight installation that runs smoothly on any systemFamiliar ribbon interface for a seamless, zero-learning-curve transition

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel select multiple cells when I only click one?

This usually happens if the 'Extend Selection' mode is active. You can tell if this is on by looking for 'Extend Selection' in the bottom left status bar. Simply press the F8 key on your keyboard to turn it off.

How can I change the default zoom level for all new Excel spreadsheets?

Excel does not have a native setting for a global default zoom. However, you can set it manually by creating a blank workbook, setting the zoom to your preferred level (e.g., 100%), and saving it as a template named 'Book.xltx' in your XLSTART folder.

Will repairing Microsoft Office fix the zoom and selection bug?

If the issue is caused by corrupted program files rather than a known version bug, running an Online Repair can help. Go to Windows Control Panel > Programs and Features, right-click Microsoft Office, select 'Change', and choose 'Online Repair'.

Excel & Data Problems