Monday, August 3, 2009


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…

1 comment: