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 ...

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

Microsoft Excel is an incredibly capable and complex spreadsheet program. If you’re just getting your feet wet, these tips will help you get started on making a spreadsheet and writing a formula. Once ...

Do you like menus? Menus tend to be overlooked in the desire to show every possible option at once in a toolbar or palette, but the nice thing about a menu is that its there when you need it and out ...

Use Excel’s built-in features to simplify data entry Your email has been sent Entering data into a worksheet can be time-consuming, and mistakes often find their way in -- but with the right tools, ...

Software packages for charting data often offer menus; i.e., lists of charts that are available. Excel offers a menu; Tableau has Show Me! Elementary statistics and graphing books offer recipes; i.e., ...