Excel selects multiple cells with mouse click - how to stop this

A

Andrew

Hello,
I am working with Excel 2007, and when I try to select a single row, 4
rows are selected. I have no macros in the system. Can some explain
why this is happening, and how to stop it?

thanks
 
P

peterfarge

Can you provide us with further information?
If you merge the cells of 4 rows, you cannot select one single row. ->
Always all 4 rows are selected.
But I don't think that your error is so easy...
 
T

Trevor Williams

Hi Andrew - you may have a cell that is formed by 4 rows being merged. hence
when you select one row within the merged cell, all 4 rows are selected.

HTH

Trevor Williams
 
A

Andrew

Hi Andrew - you may have a cell that is formed by 4 rows being merged. hence
when you select one row within the merged cell, all 4 rows are selected.

HTH

Trevor Williams






- Show quoted text -
Click to expand...

Here's a further explanation. If I select R5,C2, Excel highlights R5,
R6, and R7, and C2, C3, and C4. If I select the entire row, Excel
highlights R5, R6, and R7. The cells are not merged.
 
Top