Prev: Macro to get rid of #DIV/0!
Next: Looking a value up for a
From: PeterH38 on 31 Mar 2010 14:31
In Excel 2007, frequently when I click in one cell, the program will select
that cell plus 2 or 3 cells immediately below the cell I wanted to select.
This happened both at work (City of LA, Police Dept.) and on my home
computer. I have talked to other users of Office 2007 who had it happen to
them, also. It never happened in earlier versions of Excel, and still
doesn't on my laptop with Excel 2003. How can I get it to select only the
one cell. P.S. This seems to happen only below the top 8 or 10 rows in any
spreadsheet.
From: Gord Dibben on 31 Mar 2010 14:55
Just 3 or 4 cells or does it continue to select more as you drag around?

If the latter hit the the F8 key to toggle out of Extended mode.

If the former, try setting your Zoom level up or down a few points.

There is a bug in 2007, especially in Page Layout View.


Gord Dibben MS Excel MVP

On Wed, 31 Mar 2010 11:31:01 -0700, PeterH38
<PeterH38(a)discussions.microsoft.com> wrote:

>In Excel 2007, frequently when I click in one cell, the program will select
>that cell plus 2 or 3 cells immediately below the cell I wanted to select.
>This happened both at work (City of LA, Police Dept.) and on my home
>computer. I have talked to other users of Office 2007 who had it happen to
>them, also. It never happened in earlier versions of Excel, and still
>doesn't on my laptop with Excel 2003. How can I get it to select only the
>one cell. P.S. This seems to happen only below the top 8 or 10 rows in any
>spreadsheet.

 | 
Pages: 1
Prev: Macro to get rid of #DIV/0!
Next: Looking a value up for a