How to search in Excel effectively
How to search in Excel effectively Picture 1
Sometimes long tables of data up to hundreds of Excel pages will dazzle you if you try to find a small data item. You can not spend an hour to search each cell column by column, this is not only laborious but also very time consuming.
Thuthuatphanmem.vn will guide you how to search in Excel to be able to find information more effectively.
Please follow the example data table below.
How to search in Excel effectively Picture 2
You look at this data sheet and think you want to search for 'Vietnam' teams matches. The search keyword here is 'Vietnam'.
1. Basic search in Excel
First, you need to open the Find & Replace window pane to be able to perform the search.
Method 1: Leave the Home ribbon open , then look for the Editing section at the end of the ribbon bar on the right.
Select the Find & Select magnifying glass icon and then select the first line Find .
Method 2: Use the key combination Ctrl + F .
How to search in Excel effectively Picture 3
The Find and Replace window opens, now you can enter keywords in Fi nd what and then click Find Next to search each word.
How to search in Excel effectively Picture 4
Or choose Find All , Excel will give you a list of positions of keywords.
How to search in Excel effectively Picture 5
2. Advanced search in Excel
Except searching by keyword, Excel also allows you to search by different types of cell formats and data types.
Simplest with format search.
First, click on Options to expand the search function. Then select Format to open the search window in Find Format format .
How to search in Excel effectively Picture 6
In this window pane, there are many options to find the format for you, the most common are Font ( font format), Border (grid format) and Fill (format for cell background).
You only need to adjust the format types you want in these items then click OK .
How to search in Excel effectively Picture 7
Finally perform the same search as in the basic search method.
How to search in Excel effectively Picture 8
Thank you for following the article of TipsMake.vn on How to search in Excel, wish you can perform successfully.
You should read it
- Instructions for searching and replacing in Excel tables
- 20 'tips' use Google Search effectively, not everyone knows (Part 2)
- 20 'tips' use Google Search effectively, not everyone knows (Part 1)
- How to use the Search function in Excel
- How to Search for Words in Excel
- Instructions for finding names in Excel
- Tips and search syntax in Google effectively
- How to use Hlookup function on Excel
- How to find images, search tips and tricks effectively
- Use the search and replace function in Excel
- Share solutions when Excel does not round numbers effectively
- SEARCH () and SEARCHB () functions in Excel
May be interested
The square root formula in Excel - The square root function in Excel
How to split first and last names into 2 columns in Excel
How to create horizontal lines in Word
Cute Powerpoint Wallpaper - Collection of cute backgrounds for Powerpoint Slide
How to convert a word file to the fastest image
How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016