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?
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.