You can search for information online without leaving your Excel worksheet. The right-click menu in Excel includes a built-in search command. This feature sends selected text directly to your default web browser. This article explains how to use this function and configure your search engine.
Key Takeaways: Using the Right-Click Search Feature
- Right-click > Smart Lookup: Opens the Insights pane with web results and definitions from Bing.
- Right-click > Search the Web: Opens your default browser to search the selected text using Bing.
- Add-in integration: Third-party add-ins can add custom search options to the right-click menu.
Excel’s Right-Click Search Options
Excel provides two primary methods to search from the right-click menu. The first is Smart Lookup, which uses Microsoft’s Bing service. It displays results inside an Excel pane without opening a browser. The second is the Search the Web command. This opens a new browser tab with a Bing search for your selected text. Both features require an active internet connection. They are available in Excel for Microsoft 365 and Excel 2016 or later.
How Smart Lookup Works
Smart Lookup is powered by Bing and Wikipedia. When you select a cell’s content and use this feature, Excel sends that text to Microsoft’s cloud services. The results are returned and displayed in the Insights task pane on the right side of the Excel window. This pane shows definitions, top web results, and related Wikipedia entries. The data is processed with respect to your privacy settings in Microsoft 365.
Steps to Search Using the Right-Click Menu
Follow these steps to search for selected text directly from your worksheet.
- Select the text
Click on a cell containing the text you want to search. You can also double-click the cell and highlight a specific word or phrase within it. - Open the context menu
Right-click on the selected cell or highlighted text. The context menu will appear next to your cursor. - Choose a search command
In the menu, locate either “Smart Lookup” or “Search the Web.” Click on your preferred option to initiate the search. - Review the results
If you chose Smart Lookup, the Insights pane opens on the right. If you chose Search the Web, your default web browser will open with the search results.
Using the Search the Web Command
The Search the Web command is a direct link. It is useful for broader research or when you prefer to work in a browser. The selected text is automatically copied and pasted into the Bing search box. This happens in a new browser tab. You cannot change the search engine for this built-in command. It will always use Bing.
Common Mistakes and Limitations
Search Command is Missing from the Menu
If the Smart Lookup or Search the Web option is not visible, check your Excel version. Older versions like Excel 2013 do not have this feature. Also, verify your Office connected services. Go to File > Account > Account Privacy > Manage Settings. Ensure the “Connected Experiences” option is enabled, as this feature requires it.
Search Opens the Wrong Browser or Engine
The Search the Web command uses your Windows default browser and the Bing search engine. You cannot configure it to use Google or another site directly from Excel. To change the search engine, you must set a different default search engine in your browser itself. The Excel command will then use Bing, but your browser may redirect it based on its own settings.
Smart Lookup Pane Shows No Results
This usually indicates a network issue or a service interruption. First, check your internet connection. Second, ensure the Insights pane is fully loaded. Sometimes clicking the “Smart Lookup” header within the pane can refresh it. If the problem continues, the Microsoft Bing service might be temporarily unavailable.
Smart Lookup vs. Search the Web: Key Differences
| Item | Smart Lookup | Search the Web |
|---|---|---|
| Result Location | Inside Excel’s Insights pane | In your default web browser |
| Primary Source | Bing and Wikipedia | Bing search results page |
| Internet Required | Yes | Yes |
| User Interaction | Read results in pane | Navigate in browser |
| Customizable Engine | No | No |
You can now quickly research terms without manual copying. Use Smart Lookup for definitions and summaries inside Excel. Try the Search the Web command for more extensive online research. For advanced use, explore add-ins that can add Google search or other custom searches to your right-click menu.