Excel grays out menu commands for unavailable features or functions. To unlock the grayed-out menus, first review the most common causes, then take the steps necessary make the menu active. By default ...
From simple lists to dynamic spill ranges and cascading menus, Excel drop-downs offer flexible control over data entry.