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?

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 wrote:

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

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" wrote:

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 wrote:

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

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.

womusic wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

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

"womusic" wrote:

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?

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

"Just_Mike" wrote:

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

"womusic" wrote:

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?

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


Gord Dibben MS Excel MVP

On Mon, 11 May 2009 09:34:08 -0700, Just_Mike
wrote:

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

"Just_Mike" wrote:

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

"womusic" wrote:

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?