How to Select Specific Data in Excel (6 Easy Methods)

We have a datasheet where ID, Marks, and Student Names are given in columns B, D, and C, respectively. We will use the dataset to select specific values.

Method 1 – Use the Find and Replace Tool to Select Specific Data in Excel

Case 1.1 – Using the Keyboard Shortcuts to Select Specific Data in Excel

Steps:

• Press Ctrl + F.
• The Find & Replace dialog box will appear.

• In the Find What text box, insert the specific data you want to find.
• Click on Find All.
• You will see a list of the cells that have the text. They are also highlighted in the source data table.

Case 1.2 – Use the Find Command to Select Specific Data in Excel

Steps:

• Go to Home then to Editing and select Find & Replace.
• Select Find.

• The Find & Replace dialog box will appear.
• In the Find text box, enter the name of the student you want to find and click on Find All.
• You will get your desired output in the dialog and you can select the specific data in Excel.

Method 2 – Apply the Lookup Functions to Select Specific Data in Excel

Case 2.1 – Insert the VLOOKUP Function

We will find the marks for Anny by using the VLOOKUP Function.

Syntax: The syntax for the VLOOKUP function is:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

Steps:

• Enter the following formula in cell G5:

• Press Enter on your keyboard.

Case 2.2 – Use the HLOOKUP Function

Syntax: The syntax for the HLOOKUP function is:

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Steps:

• In cell C10, enter the following formula:

• Press Enter on your keyboard.

Method 3 – Utilize INDEX-MATCH to Select Specific Data in Excel

Let’s find the marks of a specific student named Williamson.

Steps:

• At first, select the cell you want to have the return value in. We have selected G5.
• Use the below formula in that cell or the formula bar.

• After pressing Enter, you will get an output value.

Method 4 – Apply the MATCH Function Only to Return the Position of Specific Data

Steps:

• Select cell G6 and enter the following formula:

• Press Enter.

Method 5 – Using the IF Function

We can easily find out if a student passed or failed their examination (score equal to or above 50 is a pass) by using the IF function.

Steps:

• Select the cell E5 and enter the following formula:

• Press the Enter button on your keyboard.

• Apply the same function to the rest of the cells in the dataset by dragging down the Fill Handle.

Read More: Select a Range of Cells in Excel Formula

Frequently Asked Question

How do I select specific text in Excel?

• Click and drag your mouse cursor over the text you want to select. You should see the text highlight as you drag the cursor.
• If you want to select a larger block of text, you can click and drag the cursor across multiple cells or rows.
• If you want to select non-contiguous cells or text, hold down the “Ctrl” key on your keyboard and click on each cell or section of text you want to select.
• Once you have selected the desired text, you can use any of the standard editing functions in Excel, such as copying, cutting, pasting, formatting, and so on.

How do I isolate specific data in Excel?

In order to isolate specific data, you can use the Filter tool.

You can apply a filter for a range of cells shown below, and then choose the filter parameter. We applied a filter for the Marks column and then applied a greater-than parameter as shown.

• After clicking on Greater Than, there is another window where you enter the value in the parameter box.
• Click OK.
• This will remove any value below 40.

How do I selectively copy text?

You can select specific text using the Filter tool shown above, or you can just use the Ctrl button shortcut. While pressing the Ctrl Button, click on the cell on which you wish to select. Each of those individual cells will then be selected.

Things to Remember

• Be precise: Make sure you select exactly the data you need, including any headers or labels that are associated with the data. This will help ensure that your calculations and analyses are accurate.
• Consider the type of data: If you are selecting data that includes text, numbers, and formulas, be careful not to accidentally include parts of formulas or formatting that could affect your results.
• Check for hidden data: Excel can sometimes hide data that falls outside the visible range of cells. Make sure you select all relevant data, even if it is hidden.
• Use shortcuts: Excel includes many shortcuts that can make selecting data faster and easier. For example, you can use the “Ctrl” key to select non-adjacent cells, or the “Shift” key to select a range of cells.
• Avoid overwriting data: When copying and pasting data, be careful not to overwrite any existing data that you need to keep. Use a new sheet or a different section of your spreadsheet if necessary.
• Be mindful of cell references: If you are selecting data for use in formulas or functions, make sure you use the correct cell references to ensure that your calculations are accurate.

Download the Practice Workbook

<< Go Back to Select Range in Excel | Excel Range | Learn Excel