Selected Cells Not Shaded

hi phil

thanks thats works like charm

thank you man

In Excel, I can barely tell what row is being highlighted when I select a cell. If I'm reading your answer above right, there's no way to make the selection appear darker. But all over the place, where people use screenshots to explain an excel process, I notice that the border cell (not the whole row or column) of the row and column of the cell they've selected are yellow, and can easily be seen. How did they manage that? That would be a huge improvement.

Cecilia

To fix the problem (tested on XP and W10):
- Open the registry with regedit
- Go to HKEY_CURRENT_USER, Software, Microsoft, Office, 12.0, Excel, Options
- Create a new DWORD value (not a new key !), name "Options6", change its value to decimal and give the value 16
- close the registry
Open Excel 2007, the selectionned cells now appear in like previous Excel versions (black background, text in white.

Hi all, am using Office 2010. In excel when I copy cells the function still works well as I can paste it somewhere, however, the copied cell/s used to have moving doted lines around the edges making the user aware of the cells being copied. For some reason the doted lines around the copied cells do not show anymore. Does anyone have an idea on how this can be fixed.

Best Regard
Eric Kamdem

Thanks "John Zelno" it worked for me...

So I have 2 identical Dell monitors. On one, I could NOT see a slight highlight when Ctrl multiple cell select was activated. On the other, I COULD. I simply matched the settings on both monitors, and voila... It's there, but ever so slightly.

Adjusting my monitor settings made the highlighted shading much more visible, though my screen is darker. I can switch between multiple profiles on my monitor so it's just a matter of tapping a few buttons on it when I am using excel.

John Zelno, your fix worked great!

Man, wait till he tries Excel 2013. You can no longer remove items from a set of control-click cells...

It's funny, but I have never noticed this before. I have always knew what cells I have selected by the bold outline, but I did a quick check and found that on my dual screen setup, using a Asus monitor and a Samsung monitor (Win7, Excel 2007) that the highlighted cells are different on each monitor. On the Asus they are gray, but off-white on the Samsung. This gives me the conclusion that it is the displays and not Excel. On my Dell laptop they are more gray then white.

I had found this to be a problem with Excel 2007 on Win XP. On Win 7, the contrast in 2007 seems to be much better. Also, with Excel 2010, the contrast is also much better than in 2007 (at least on Win 7... I haven't tried 2010 on XP). For 2007 on XP, I was able to adjust the windows settings to acheive a better contrast. Follow these steps in XP to acheive this:
1.In the Windows Display Properties, select the Appearance Tab
2.Click the Advanced button
3.Under Item, select Window
4.Pulldown Color 1, and select Other...
5.Select the White square under "Basic Colors", change the Lum value to 215, then click Add to Custom Colors
6.Select the (new) grey box under "Custom colors:" and press all of the OK buttons

I have Excel 2007, and selected cells are shaded, although light, but very visible. As far as I know, I haven't done anything to achieve that; it just "came that way."

I have Excel 2007 on my computer. When I make a selection or control-click cells to achieve non-adjacent selections, Excel 2007 does indeed shade the selected cells; it is a very light shading, though. Try tweaking your display settings for brightness and contrast until you can see the light shading. This can also be achieved in Windows Explorer: when you view "details" and sort by a column heading, that sorted column has a light background shading that is hard to see if your display settings are not tweaked properly. (I use Windows XP.) Secondly, once you tweak your software settings, then try tweaking your hardware settings: your monitor controls will allow you to get a good balance. Good luck!