Wakelin Solutionz Pty Ltd

SPECIALISTS IN PERSONAL & ORGANISATIONAL PRODUCTIVITY

Phone: +61 421 551 254      Email:  wakelinsolutionz@bigpond.com

Stop a user pasting invalid information into a cell containing data validation

You can not stop a user pasting invalid information into a cell containing data validation, but you can circle the cells containing the invalid data so any errors are clearly visible

1. Click on the Tools menu

2. Click on Formula Editing

3. Click on Show Formula Auditing Toolbar

4. Click on the icon for Circle Invalid Data

5. To clear the circles, click on the icon for Clear Validation Circles

Excel Tips Index