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