Can't see selected cells in Excel

Posted on 2011-10-20
Medium Priority
Last Modified: 2012-08-14
I have a user on Excel 2010 who has a problem. Whenever she opens an Excel spreadsheet and selects some cells, nothing appears.

Normally, when you select cells in excel, you'll see a solid black outline of the cells you are selecting along with a blue background shading. She does not see either of these.

We know the selection is working because excel displays the cells that are being selected in the top left corner. Also, if she selects cells and makes some formatting change, the changes apply the cells she was trying to select - there's just nothing to indicate that the cells are selected.

This just occurred after uninstalling Office 2010 Home/Business from the Click-to-Run installer (comes on OEM Dell machines) and using physical media to reinstall.
Question by:DVation191

Accepted Solution

Davy2270 earned 2000 total points
ID: 37000178
If the problem still persists after you have restarted your computer again, I would uninstall Office from the control panel's 'Add or Remove Programs'. And then install Office again from the physical media.

LVL 11

Expert Comment

ID: 37001386
You might want to try the repair option from the control panel before a full reinstall.  

Also, there was a choice made on office 2010 to choose speed over interface with incompatable display drivers.  Often users have to scroll the worksheet down, and then scroll back up to refresh their screen if they have one of these "incompatable drivers"

I'd have her scroll down and then back up and see if if the highlighted items are now showing.  Also you'll want to get best display/video driver you can and see if that fixes the problem.


LVL 11

Expert Comment

ID: 37023176
I think Gridlines are disable. Have you tried it ?

In view Option. Select Gridline box checked.
LVL 20

Author Comment

ID: 37024453
Oddly, rebooting fixed the problem. Weird!

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question