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;
https://www.computergaga.com

*** 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

#MsExcel #ExcelTips