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.