Unable to tell which cells or rows I'm selecting when copying data in 2010

[bobbyb007]

I received a spreadsheet from a coworker and I had to make some changes which included copying a range of cells into another spreadsheet. When I try to use the mouse to select data the selected cells do not change to a darker color to let me know which cells I'm attempting to copy. It does let me copy but I am operating somewhat blind. I checked and it does not appear that the worksheet is protected. Why this behavior?

 

[pbornemeier]

Can you see the selected cells in other workbooks? If not, your monitor/graphics card may not be optimally adjusted.

Does the black border appear around the selected cells?

Does the name area show the size of the selection (something like 4R x 3C) while you are selecting cells?

This post discusses changing the colors of cells while they are selected:
http://www.mrexcel.com/forum/showthread.php?t=524640

I am not sure if there is a style that affects only the selected cells in Excel 2010. I'll check when I get to machine that has 2010 installed.

Is it a template file? .xlt, .xltx, .xltm

 

[bobbyb007]

Now I'm evem more stumped. I finally had a minute to revisit this problem and Excel 2010 (which we just converted to maybe 2 weeks ago) is behaving as expected. The only thing that changed was I completely shut down all apps and logged out of my account as I do every night but to answer your questions.

1. I was able to see cells selected in other workbooks.

2. The black border did not appear around the cells.

3. I'm not sure if it had anything to do with the styles but I don't recall changing styles.

4. It was an .xls file. I've noticed that in 2010, unlike 2007 it appears to be defaulting to .xls versus .xlsx like what I was used to in 2007.

I do recall reading something about how many people had complained about some sort of compatibility issue with 2007 and pre 2007 documents and that MS was considering going back to the old formats. You would probably know better than me.

Bottom line for now is the problem has gone away. If it happens again I'll try to capture more diagnostic info.

Thanks alot for responding to my request...Take care,

Bob B.