I have rearranged a spreadsheet that has merged cells. This has resulted in
an odd behavior I have not seen nor do I know how to fix it. The cursor
click now will select several cells in the column. So I can't get at a
single cell in most cases. The behavior is somewhat random as to how many
cells are selected. Frustrated!

Hi Dann,
The problem is that you still have some merge cells, highlight the whole
spreadsheet and click on merge, it will solve your problem
If this helps please click yes, thanks

"Dann" wrote:

I have rearranged a spreadsheet that has merged cells. This has resulted in
an odd behavior I have not seen nor do I know how to fix it. The cursor
click now will select several cells in the column. So I can't get at a
single cell in most cases. The behavior is somewhat random as to how many
cells are selected. Frustrated!

My best guess is you hit F8 which truns on multi-select. Try hitting F8 again
to turn it off.

Note that when you do this the letters EXT toggle on and off in the bottom
right corner of the XL window...
--
HTH...

Jim Thomlinson


"Dann" wrote:

I have rearranged a spreadsheet that has merged cells. This has resulted in
an odd behavior I have not seen nor do I know how to fix it. The cursor
click now will select several cells in the column. So I can't get at a
single cell in most cases. The behavior is somewhat random as to how many
cells are selected. Frustrated!

I had to unmerge the spreadsheet in 2003 version. BUt this did not work when
ported to 2007 version. It still selects many cells not just one. I will
have to work with the sheet in 2003 until I can figure it out in 2007.

"Eduardo" wrote:

Hi Dann,
The problem is that you still have some merge cells, highlight the whole
spreadsheet and click on merge, it will solve your problem
If this helps please click yes, thanks

"Dann" wrote:

I have rearranged a spreadsheet that has merged cells. This has resulted in
an odd behavior I have not seen nor do I know how to fix it. The cursor
click now will select several cells in the column. So I can't get at a
single cell in most cases. The behavior is somewhat random as to how many
cells are selected. Frustrated!

Try setting the Zoom level a little lower or higher.

The multiple cell selection is a bug in Excel 2007.

The zoom-changing appears to fix it.

A few postings have made the suggestion and it seems
to work.

Here is one such posting.

http://tinyurl.com/3wofsf

I have received replies to this advice indicating the zoom change clears it
up.


Gord Dibben MS Excel MVP


On Tue, 26 May 2009 13:19:01 -0700, Dann
wrote:

I had to unmerge the spreadsheet in 2003 version. BUt this did not work when
ported to 2007 version. It still selects many cells not just one. I will
have to work with the sheet in 2003 until I can figure it out in 2007.

"Eduardo" wrote:

Hi Dann,
The problem is that you still have some merge cells, highlight the whole
spreadsheet and click on merge, it will solve your problem
If this helps please click yes, thanks

"Dann" wrote:

I have rearranged a spreadsheet that has merged cells. This has resulted in
an odd behavior I have not seen nor do I know how to fix it. The cursor
click now will select several cells in the column. So I can't get at a
single cell in most cases. The behavior is somewhat random as to how many
cells are selected. Frustrated!