excel 2007 click selects multiple cells

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?
 
M

marathon-man

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.
 
L

lanrover5

Clicking near the top of the cells seems to select the single cell. Clicking
towards the bottom of the cell triggers the "bug".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

single click selects multiple cells 13
Single click selects multiple cells 7
Excel 2007 highlights multiple cells when trying to select one. 5
Mouse selects only multiple cells 10
One Click = Multiple Cells in Excel 2007 2
help fix - - one click now selects multiple cells in Excel 2007 5
Microsoft Excel 2007 highlights multiple cells in Excel 1
Selects 4 Cells with 1 Click?! Help!! 2

Top