Solved Excel 2010 is automatically selecting multiple rows & cells

March 29, 2012 at 14:07:20
Specs: Windows 7
why is my Excel 2010 automatically selecting multiple rows or cells, when I select a single row or cell? Columns are okay, clicking on one column header selects only that column header.

In my attempt to insert a single row, I would normally single click the row heading to select that row, then I want to right click on the selection and choose Insert.
EXCEPT, that when I select a single row heading, 3 more rows below would automatically select.
What I noticed is that this only happens in the Page Layout view (Excel 2010). When I switch view to Normal, it does not happen. Also, this happens only below a certain row number.

Is this a setting somewhere?


See More: Excel 2010 is automatically selecting multiple rows & cells

Report •


#1
March 29, 2012 at 15:35:59
✔ Best Answer
At this point most of us believe that to be a bug in Excel 2007 and later. If you Google the problem you'll see lots of other people asking about it.

I ran into the issue the other night when I couldn't select a single cell.

Some have suggested changing the zoom level to fix it.

Google around and see what others have said.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
March 29, 2012 at 17:02:03
Thanks, did that. I guess you're right.... just a bug

Report •

#3
March 29, 2012 at 17:12:35
"Just a bug" makes it sound trivial. :-)

In my mind it's a pretty serious bug. I would hope that MS is monitoring (and working on) the issue.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
March 29, 2012 at 19:22:58
Sorry, not trivial at all! that was the sound of me giving up... actually so very frustrating! For me the 2 workarounds that worked were the switching to Normal view and tapping the arrow keys. I agree totally about MS acknowleding this.

Report •

#5
June 14, 2012 at 10:08:50
Someone answered a real quick fix. Just don't have your page maximized. I have the same problem, after about 10 minutes working in a spreadsheet it starts up.


Report •


Ask Question