Cell selection in Excel 2007

D

Donna

A friend is using Excel 2007 and is experiencing a strange (and sporadic)
problem in a specific workbook. When she clicks a cell, sometimes 2, 4 or 8
cells will automatically be selected. She did not activate the F8 key or
sticky keys.

I have asked her to change the mouse and retry (doubt this is the problem,
it only occurs in a specific file).

Also asked her to do a Save As to create another file. Not sure if this
would solve the problem since it would probably be created in new workbook.

Also asked her to copy info from a sheet in problem workbook to a sheet in a
new workbook. Obviously this is not ideal since she will loose formatting.

She really needs an answer ASAP so I am asking for other solutions not even
knowing if mine will do the job.

Any suggestions would be appreciated!

Thank you!
 
B

Bob Greenblatt

A friend is using Excel 2007 and is experiencing a strange (and sporadic)
problem in a specific workbook. When she clicks a cell, sometimes 2, 4 or 8
cells will automatically be selected. She did not activate the F8 key or
sticky keys.

I have asked her to change the mouse and retry (doubt this is the problem,
it only occurs in a specific file).

Also asked her to do a Save As to create another file. Not sure if this
would solve the problem since it would probably be created in new workbook.

Also asked her to copy info from a sheet in problem workbook to a sheet in a
new workbook. Obviously this is not ideal since she will loose formatting.

She really needs an answer ASAP so I am asking for other solutions not even
knowing if mine will do the job.

Any suggestions would be appreciated!

Thank you!
You have landed in a Macintosh group. You mentioned Excel 2007, which is
Windows, but I think the problem and solution are the same. Is she really
clicking a cell, or actually double clicking expecting to edit the cell. If
the later, make sure the Excel preferences for 'allow double click to edit
directly in cell." If this preference is turned off, double clicking a cell
will automatically select the cell's precedents. This is probably what is
happening.
 

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

Top