Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation

Data Validation

ResolvedVersion 2010

Tue 11 Jul 2017, 15:27 Delegate Kane said...

Kane has attended:
Excel Advanced course
Excel Advanced course

Data Validation

Hi,

I have put data validation on cells so the it has to be 11 characters long only. However, if you cut and paste less or more in the cells the data validation does not work. Is there a way around this please?

Regards

Kane

Thu 13 Jul 2017, 10:21 Trainer Jens said...

RE: Data Validation

Hi Kane,

Thank you for the forum question.

It can be done, but you will have to write a VBA code in the workbook. I do not know if you have VBA knowledge if not unfortunately you cannot prevent someone to paste into the cells with datavalidation.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 20 Jul 2017: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Data Validation

Data Validation

RE: Data Validation

Excel articles

Excel tip:

Sorting data stored in rows