• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Search in Excel

June 7, 2021 by Andrew Childress
How to search in Excel

When you work in large spreadsheets, it’s often useful to search for certain text, values, or characters. Here's how to search in Excel.

When you work in large spreadsheets, it’s often useful to search for certain text, values, or characters. Needless to say, this is a tedious process to do manually. Fortunately, Excel has built-in search features that you can use to quickly find the information you need. Let’s learn how to search in Microsoft Excel.

How to Search in Excel (With Key Commands)

There are two quick ways to perform searches in Excel. The easiest and simplest helps you find values by inputting a simple key command on Windows or Mac.

Consider a spreadsheet full of data. You want to quickly find the name “John” contained in the workbook. To do it, press Cmd + F on your keyboard. (On Windows, use Ctrl + F on your keyboard).

Excel will open the Search Sheet box in the upper right corner of the menu. Click and then type in your search value. In this example, that’s John. Hit Enter, and you’ll see the first cell containing the value is now selected in your worksheet.

Search Excel

To find other usages of your search term, you have two options. You can hit Enter on your keyboard again, and Excel will continue moving through the results of your search. Or, you can use the arrows in the Search Sheet box to move both forward and backward through your data.

How to Search in Excel (On the Home Tab)

The second easy search feature in Excel lives on the Home tab on the ribbon. It’s more robust and gives you better flexibility as you search.

On the Home tab, find the Find & Select dropdown on the right side.

Search in Excel

Clicking on Find launches a menu box with several options. It gives you more search control, and allows you to search a full workbook.

You can search within rows, and specify exact or partial case matches. Make your selections, and click Find Next in the lower right corner. Excel will repeat your search, operating within the outlined parameters.

How to search in Excel

As you can see, it’s easy to search in Microsoft Excel. This makes it a breeze to find values in even the largest and most complex workbooks.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « make a gantt chart in Excel Gantt Charts in Excel
Next Post: Bell Curve in Excel How do I make a bell curve in Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top