In this video, we have a quick Excel tip on how to edit all of the cells contain a Data Validation rule at the same time.
I was asked this recently on a course. Because it is not always clear when working with others spreadsheets – where the Data Validation rules were set up.
But this is no problem. And this video will show you how to edit them quickly.
Find more great free tutorials at;
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► http://bit.ly/2LVuHDW
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► http://bit.ly/2klIl6H
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J
Connect with us!
Google+ ► https://plus.google.com/+Computergaga
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1