How to search for words in Excel

Author: Janice Evans
Date Of Creation: 1 July 2021
Update Date: 1 July 2024
Anonim
How to Do a Search on an Excel Spreadsheet : Microsoft Excel Help
Video: How to Do a Search on an Excel Spreadsheet : Microsoft Excel Help

Content

An Excel spreadsheet can be so huge that it becomes difficult to navigate through it. Therefore, to search for words (or phrases), it is better to use the search function.

Steps

Part 1 of 2: Opening an Excel Worksheet

  1. 1 Start MS Excel by double clicking on the program shortcut on the desktop.
    • If there is no program shortcut on the desktop, start Excel from the Start menu.
  2. 2 In Excel, click File - Open. In the window that opens, find the file you need.
  3. 3 Highlight the Excel file and click Open.

Part 2 of 2: Finding Words

  1. 1 Click on any cell in the table to make sure it is active.
  2. 2 Press Ctrl + F. A search window will open with two tabs "Find" and "Replace".
  3. 3 In the "Find" line, enter the word or phrase you want to find and click "Find" (in the lower right corner of the window).
    • Excel starts searching for the word (or phrase) you entered. Words found in the table will be highlighted.