Left mouse click keeps extending selection of desired field to encompass four fields in Excel whenever attempting to enter data into a field.

Question

Left mouse click keeps extending selection of desired field to encompass four fields in Excel whenever attempting to enter data into a field.

Christine Pittman 0

Seems to be just ONE excel sheet this occurs in (some setting I don't know how to access/search?), so it is NOT a global mouse setting (though I went ahead and checked the mouse settings AND performed a shift F8 and still no resolution in this one excel sheet.)

Bottom line, how do I stop the left mouse clicker from extending a selection multiple rows when I just want a single field opened in the sheet? (BTW, right clicker is ok/allows this, but I use the left, so it is awkward/greatly slows me down having to use the right one.)

Thanks!

0 comments

1 answer

Your answer

Answer 1

Manoel Barros 22,055 Independent Advisor

Hi!

What exactly are you using in that spreadsheet that triggers the problem? Tables, complex formulas, VBA, macros, or conditional formatting?

To identify the cause of the issue specific to that spreadsheet, you need to look for elements present in it—but not in the others—that could be causing this.

Christine Pittman 0 Reputation points

2026-10-06T16:40:24.07+00:00

Just a basic ledger (like a checkbook) of debit and credit columns with running total at end of row. The fields I am trying to edit, however, do not contain any computation formulas and are just text description fields (like where you would enter a description of what the credit or debit was for....like "accountant fee for 2025 tax return prep", etc.)