Buzz
In this guide, I'll walk you through detailed steps on how to effectively search in Excel so you can find information more efficiently.
GUIDE ON HOW TO SEARCH IN EXCEL
Let's say you have data as shown below and you want to find students with Total Score of 20, so your search keyword is '20'.
To search in Excel, you can perform Basic Search or Advanced Search in Excel.
1. Basic Search in Excel
Step 1: Go to the Home tab -> at the end of the toolbar on the right, you'll see the Editing section -> select the magnifying glass icon Find & Select ->then choose Find (or you can press the shortcut keys Ctrl + F)
Step 2: The Find and Replace dialog box appears -> enter the keyword into Find what -> then click Find Next to search for each occurrence.
Alternatively, select Find All, Excel will immediately provide you with a list of locations where the keywords have been found:
2. Advanced Search in Excel
Apart from searching by keyword, Excel also allows you to search by different cell formats and data types.
For example, searching with specific formats. To search, follow these steps:
Step 1: In the Find and Replace interface -> click Options to expand additional search functionalities.
Step 2: Then, choose Format to open the Find Format search window.
In this window, there are many formatting options for you, among which the most commonly used are Font, Border, and Fill -> press OK after making your selections.
Step 3: Finally, perform the search just like in basic search:
You see, Searching in Excel is really simple, isn't it! This search helps you quickly find any errors so you can fix them immediately and efficiently. Additionally, if you're looking for self-learning Excel resources, check out the top Excel learning websites, reputable Excel training centers for self-study. Wish you success!
Switching between Word and Excel is always a crucial need for many Microsoft Office users, check out how to convert Word file to Excel on Mytour to understand more about this trick.
