How to search in Excel effectively

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.

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 .

The Find and Replace window opens, now you can enter keywords in Fi nd what and then click Find Next to search each word.

Or choose Find All , Excel will give you a list of positions of keywords.

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 .

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 .

Finally perform the same search as in the basic search method.

Thank you for following the article of TipsMake.vn on How to search in Excel, wish you can perform successfully.