I love Excel.  How often have I said and posted some coll/nerdy thing about it!? Lots – I should make a formula to help me calculate the time 🙂

This is one that was bugging me for  a while now.  If you have an existing table with data in it how do you copy validation rules on top of the existing cells while maintaining their current value?

All the paste options don’t do this… but there is Paste Special.  I had totally forgotten about it . For work, I needed this to work so I spent a bit of time trying to actually (finally) figure out how to do it.

As it turns out it is very simple:  Paste Special has the option to paste validations. Done!