Tuesday, 28 November 2017

Excel - Data Validation Dropdown Arrows Not Visible

Occasionally, data validation dropdown arrows are not visible on the worksheet, in cells where you know that data validation lists have been created. The video shows the most common reasons for missing arrows, and the written instructions for fixing the problems. 




Invalid Entries Are Allowed

Data Validation on a Protected Sheet

Make the Dropdown List Temporarily Wider

Make the Dropdown List Appear Larger








Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London

No comments:

Post a Comment