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.

Excel intuitively selects the list range, which usually consists of multiple columns. Click OK, and Excel will create the list shown in Figure B by adding drop-down controls to each header cell.

In this post, we show you how to change color of ActiveX Control buttons in Microsoft Excel, Word, PowerPoint programs.

Excel’s Table object isn’t supported in the menu version, so #3 won’t work in .xls files. The browser version supports existing validation controls, but you can’t create them or modify ...