ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   multiple cells are often selected when I click in only one cell (https://www.excelbanter.com/excel-worksheet-functions/260379-multiple-cells-often-selected-when-i-click-only-one-cell.html)

PeterH38

multiple cells are often selected when I click in only one cell
 
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.

Gord Dibben

multiple cells are often selected when I click in only one cell
 
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
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.




All times are GMT +1. The time now is 01:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com