excel 2007 click selects multiple cells

  • Thread starter Thread starter marathon-man
  • Start date Start date
M

marathon-man

In the last couple of months, when I click on a single cell in my .xls
spreadsheets, two or more cells get selected. Very annoying! Other people
have reported it in other forums, but no solutions.
When I right-click and hold, I see "1R x 2C" or similar in the top left
corner, as if I'm shift-selecting.
The problem goes away if I do any of the following:
- switch from Page Layout to Normal view
- unmaximise the spreadsheet
- change the zoom from 100% to something else.
Is this a known bug?
 
I'm afraid not. There are at least 4 threads regarding this problem in the
Excel forum, the earliest I've found being 13th July 08, so I'm guessing that
MS introduced a bug to Excel 2007 shortly before this and broadcast it to all
of us on patch Tuesday. The workaround is to fiddle with the zoom or switch
to full page view not print layout view.
 
Clicking near the top of the cells seems to select the single cell. Clicking
towards the bottom of the cell triggers the "bug".
 
Back
Top