Highlighted Cells

[BlindGuy]

When I click on ONE cell I get 3 others below it that also highlight. This problem is only specific to the one spreadsheet. How do I stop it and go back to the normal one cell?

 

[Dazzawm]

What excel are you using and when you say highlighted are they coloured in?

 

[BlindGuy]

I'm using 2007 and yes the other cells do color in.

 

[Dazzawm]

Someone may correct me but you have have conditional formatting turned on to highlight duplicate cells. Try going to Home>Conditional Formatting>ClearRules>Clear Rules From Entire Sheet and see if that helps.

 

[BlindGuy]

Sorry, it didn't help.

 

[VoG]

Right click the sheet tab and select View Code. Is there any code?

 

[BlindGuy]

No there is not

 

[NBVC]

If you are zoomed in.. try zooming back to 100%

If you have changed views, try going back to another view...

These are a couple of issues that have caused this problem to people in XL2007.

 

[BlindGuy]

It seems that whenever I have the header showing on the page I have the issue. When I do not have the header showing, it doesn't do it.?

 

[NBVC]

You mean in Page View?