Why?

So, I’ve inserted a row in Excel under another row that has colored cells and data validation. Then I select to clear formatting. Why does it clear the formatting and not the data validation? I know data validation is not formatting (the ribbon tabs make that very clear), but why would I want to clear one and not the other? Why doesn’t it give an option to clear both? What if I wanted to clear validation but not formatting? No luck for me…

Welcome and today's bug

Welcome!  I have to say first that I didn't come up with Excel Ninja, but I like it, so it stays. :-)  I started doing work in Excel and VBA almost by accident, and now, spend 1/3 of my time at work on Excel based solutions.  I wouldn't say I'm an expert, or even that great at it.  But I enjoy doing it and have learned quite a bit along the way.  Hopefully I can share some of that knowledge here, as well as ponder other ponderables such as my first bug report...  Enjoy!

===================================

I have to say that for the most part I really like Excel 2007, but it has some bizarre bugs and missing functionality.  Bug of the day - can't unhide columns.  I hid some columns, then went back to unhide them and no luck.  No worksheet or workbook protection, just hidden columns.  I select the entire sheet, then right click > unhide, nothing.  I select the columns to the left and right, same thing.  So, I turn to my friend Google (slightly ironic that one of Microsoft's biggest competitors offers the best help when things go wrong!).

I found this link that solved my problem: "Perhaps the column isn't actually hidden, but its width is very small. Try selecting columns to left and right and use Format > Column > Width, putting something sensible (say 8)."

I already knew that hiding a column is the equivalent of setting it's width to zero, but why not be able to unhide?  Who knows, but it worked.  I've got my columns back, but I am still quite baffled.

Am I way off base here?