More than one cell is selected when I left click. Why?

[womusic]

I have an Excel 2007 worksheet. When I left click on a cell, instead of that
cell having a box around it, the selection box is around that cell and 5
others under it. And when I try to select a row, that row and five below it
are selected. How do I fix this?

 

[Dave Peterson]

I'm betting that you have merged some cells. This gives the appearance of a
giant cell.

Rightclick on that cell
Format|cells|alignment tab|uncheck merge

(select all the cells on the worksheet first to get get rid of all these merged
cells)

 

[womusic]

Thanks for the info. I went back in to try it but it's not doing it anymore.
Strange. Thank you anyway though.

 

[Dave Peterson]

Excel makes it possible to extend a selection. You can toggle this by hitting
the F8 key (it's a toggle key).

Maybe you were in extend mode when you had your earlier trouble.

 

[Just_Mike]

ME 2,
and it's driving me mad I say, though I am not a new user, this thread was
the only place I found the problem addressed and F8 nor merged cells are the
problem ....or solution

 

[Just_Mike]

By the way I've found this only happens in the page layout view

 

[Gord Dibben]

Make small changes to the Zoom factor and see if the problem goes away.


Gord Dibben MS Excel MVP