Tell Me Box - Excel Glossary

Introduced in Excel 2016, the Tell Me Box revolutionized command discovery by replacing traditional menu diving with intelligent search. Users type what they want to accomplish (e.g., 'sort data', 'insert chart', 'calculate average') and receive contextual suggestions with direct access to commands and help articles. It understands synonyms and partial phrases, making it forgiving of imprecise terminology. The feature integrates with Excel's ribbon structure, showing command locations and offering one-click execution, significantly reducing the learning curve for new features and improving productivity across all skill levels.

Definition

The Tell Me Box is Excel's AI-powered search interface that helps users quickly find commands, features, and functions by typing natural language queries. Located in the ribbon's top-left, it eliminates menu navigation and accelerates task completion for both beginners and advanced users.

Key Points

1Natural language search: Type what you want to do, not technical command names
2One-click execution: Apply commands directly from search results without additional navigation
3Help integration: Access tutorials and support articles alongside command suggestions

Practical Examples

→A user types 'freeze panes' to lock header rows without navigating View > Freeze Panes manually
→A financial analyst searches 'pivot table' to quickly access table creation tools for data summarization

Detailed Examples

Sales manager needs to create a chart quickly

Instead of navigating Insert > Chart, the manager types 'insert chart' in Tell Me Box, selects the chart type from suggestions, and creates the visualization in seconds. This accelerates reporting and reduces time spent learning ribbon locations.

Finance professional searching for conditional formatting

By typing 'highlight cells' or 'color scale', the user discovers conditional formatting options without knowing the exact feature name. Tell Me Box displays the command path and opens the formatting dialog directly, improving feature discoverability for complex operations.

Best Practices

✓Use conversational language: Type 'how do I merge cells' rather than searching technical terms like 'merge' for better relevance.
✓Combine Tell Me Box with keyboard navigation: Press Alt+Q to focus the box, then type and press Enter for fastest workflows.
✓Explore Help results: Don't skip help articles provided in suggestions—they often include related features you didn't know existed.

Common Mistakes

✕Searching too specifically: Avoid overly technical or exact command names; use simple, descriptive phrases instead to improve search matching.
✕Ignoring help results: Many users click the first command result and miss help articles that explain related features and best practices.

Tips

✓Press Alt+Q as a keyboard shortcut to instantly activate Tell Me Box from anywhere in Excel
✓Bookmark frequently used commands by clicking the star icon in results for faster future access
✓Use partial words: 'chart' finds both 'insert chart' and 'edit chart' for broader discovery

Related Excel Functions

SEARCH FIND FILTER VLOOKUP

Frequently Asked Questions

Is Tell Me Box available in all Excel versions?

Tell Me Box is available in Excel 2016 and all later versions, including Excel Online. However, feature availability and search results may vary slightly across versions.

Can Tell Me Box understand misspellings?

Yes, Tell Me Box has fuzzy matching and understands common misspellings. For example, typing 'feeeze panes' will still find the freeze panes command due to intelligent error correction.

Does Tell Me Box work offline?

Yes, basic command searches work offline in desktop Excel. However, help articles and some advanced suggestions may require internet connectivity to display fully.