Quick Excel Tip: Edit Data Validation Rule for All Same Cells

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

Connect with us!

#MsExcel #ExcelTips

[sasavienne]

Yes. All your tutorials are useful. I can not count how much I could learn through your impressive and highly appreciated tutorials. Thanks Alan. 👍 🌟

[Chef-]

Great little tip and neat workaround to amend all cells at once. Glad you posted this. Keep up the fab work and helpful videos.
regards

[wayneedmondson]

Hi Alan.. your videos and tips are always useful and entertaining. Thanks for this one and Thumbs up!

[smithc]

Hi, these are very helpful tips for everyone thank you. Could help me solve a problem. I spreadsheet with data validation set up and on entering data it allowed me to input the heading beginning with the the same letter, is there a way to stop this? your help would be much appreciated.

[AdhamMohamed-mypp]

I want to set two option but words : ex to type only conforms / not conforms !? How should I customize that ?