Instructions for searching and replacing in Excel tables

In order to be able to process statistics and statistics tables, Microsoft Excel is the best support office tool, enabling users to perform various calculations. In the process of working, sometimes you will have to constantly change the data to meet the needs of the job. However, with Excel spreadsheets containing hundreds of thousands of data, how will we search and replace? Is it the only way to do it manually and replace it?

The answer is no. Surely for those who regularly work with Word will know how to search, replace, move quickly. And in Excel, we can completely search and replace in the fastest way, without wasting time searching and searching each data. Your work will shorten the time and still achieve high efficiency. For details on how to perform search and replace operations in Excel, please read the following tutorial of Network Administrator.

1. How to search in Excel spreadsheet:

Step 1:

First of all, open the Excel data sheet to work. At the Home tab on the Ribbon, we click the left mouse button on the Find & Select item. Then go to Find or press Ctrl + F.

Instructions for searching and replacing in Excel tables Picture 1

Step 2:

The Find and Replace dialog box appears shortly thereafter. Here, you will enter the word or data to search into the Find What box . For example, I want to find the position of number 45.

Instructions for searching and replacing in Excel tables Picture 2

Step 3:

In this next step, we will have two options to implement.

1) If you select Find Next:

This means that I will find each data one by one, the word that is requested and the result will show the position of the number 45.

The first position of the number 45 will be in column B4 in the data table and be framed.

Instructions for searching and replacing in Excel tables Picture 3

If we click continue to Find next , will be the next position of the number 45 in column C6 as shown in the picture, also framed for easy identification.

Instructions for searching and replacing in Excel tables Picture 4

You continue to follow the above operation to find the remaining values ​​in the spreadsheet.

2) If you select Find all:

This will summarize all the positions that the word, the data we want to find and the statistics right below for you to know.

The result will give 2 positions of the number 45 in the Excel worksheet, in Book 1 and Sheet 1. When you click on a certain line, immediately appear position 45 in the table is also framed, for example like B4.

Instructions for searching and replacing in Excel tables Picture 5

2. Alternative in Excel spreadsheet:

Step 1:

We also open the Excel file to work. In the Home tab, click the Find & Select item but select Replace , or press Ctrl + H.

Instructions for searching and replacing in Excel tables Picture 6

Step 2:

The Find and Replace dialog box appears. You enter the word to replace in the Find what box and type the replacement word in the Replace with box .

Instructions for searching and replacing in Excel tables Picture 7

Step 3:

Word replacement and data in Excel also include 2 different options.

1) If you select Replace:

If the user needs to replace each position with different numbers, click this item.

As shown in the picture, I choose Replace to replace the 2 position number 45 in the table at B4 and C6. At position B4 has changed 45 to 30. As for position C6, I change the value to 45 to 25.

Instructions for searching and replacing in Excel tables Picture 8

You continue to follow the above action to change other numbers and characters in turn.

2) If Select Replace All:

If we need to replace all 1 numeric values, characters with 1 number or other characters , click this item.

Here, I will replace the number 45 with the number 15 at all locations in the data table and click Replace All .

Instructions for searching and replacing in Excel tables Picture 9

Soon after, a notice of the number of locations found and was replaced. Click OK .

Instructions for searching and replacing in Excel tables Picture 10

The result will be the data table that changed the number 45 to 15 with the two positions B4 and C6 as shown below.

Instructions for searching and replacing in Excel tables Picture 11

Above is a detailed tutorial on performing search and replace operations on Excel spreadsheets. With this approach, we will quickly search and replace values ​​with a few simple steps. Besides, you can also choose to find or replace each value or the entire value in Excel data.

Refer to the following articles:

1. Summary of expensive shortcuts in Microsoft Excel

1. 10 ways to recover corrupted Excel files

1. You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!

I wish you all success!