There were times when I was working in a spreadsheet and I had to do a quick internet search to understand some of the words in my cells.

The process was, copy the text, paste on my browser, and click search.

Little did I know that in Excel 2016, there is a feature called Smart Lookup! Smart Lookup allows me to make word searches inside Excel!

Let us say we want to know more about these names in our spreadsheet:

smart-lookup-01

 

DOWNLOAD EXCEL WORKBOOK

 

The steps are very straightforward, which are outlined below:

STEP 1: Pick first the name or cell containing the text you want to search:

smart-lookup-01

 

STEP 2Go to Review > Smart Lookup:

smart-lookup-02

 

STEP 3You can now see my picture and details inside Excel which is using Bing’s web search inside the Smart Lookup pane! Thanks Smart Lookup!

smart-lookup-03

smart-lookup

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Add the Calculator to the Excel Toolbar There were times when I had to find my Calculator App while I was doing some quick calculations in Excel. Instead of scrambling for the Calculator Application, you can actually have this inside of Excel! Excel has a lot of customizations and one handy tool is to include the...
How to Group Worksheets in Excel Ever had a time when you needed to modify data across multiple worksheets?  It is very easy to do this using the Group Worksheets feature in Excel! Let us say we have this same mistake on multiple worksheets -  see the Dvv typo in the screenshot below.  We want to change this ...
How to Lock Cells in Excel Have you encountered a scenario where you do not want to lock the whole sheet, but just a couple of cells in your Excel worksheet? Locking an entire sheet is straightforward, but locking separate cells is a different story. Let us say, we have this single cell that we want ...
How to Unhide Columns in Excel We normally use "helper columns" to do calculations in our Excel worksheet.  These "helper columns" are for our own internal use and we usually hide these columns so no one else can see them, like our evil boss! But once we are done with presenting our Excel worksheet to our e...