Pinterest Pixel

Smart Lookup in Excel 2016

  There were times when I was working in a spreadsheet and I had to do a quick... read more

Download Excel Workbook
Bryan
Posted on

Overview

 

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 in Excel 2016

 

Smart Lookup in Excel 2016 | MyExcelOnline

download excel workbook Smart-Lookup.xlsx

 

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 in Excel 2016

 

STEP 2Go to Review > Smart Lookup:

Smart Lookup in Excel 2016

 

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 in Excel 2016

 

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

See also  How to Lock Cells in Excel
Smart Lookup in Excel 2016 | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!