Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Limit Your Search to a Column in Excel

Excel allows a user to limit a search of value to a single column. This step by step tutorial will assist all levels of Excel users to learn how to limit a search to a column in Excel.

Figure 1. Searching in a single column

Setting up Our Data for Searching in a Column

Let’s look at the structure of the data we will use. In columns B and E, we have products. In column C, there are amounts and in column D, percentages. In column F, we have total amounts.

Figure 2. Data that we will use in the example

Limit a Search to a Single Column

In our example, we want to search for “Product D” in column B. As we have products in both columns B and E, we must limit our search to column B only.

To enable this, we first need to select a column in which we want to search, in our case, column B. We need to click on column B name, as shown in Figure 3.

Figure 3. Select a column for the search

Now we can press Ctrl+F or go to the Home tab, the icon Find&Select and choose the Find option.

Figure 4. The result of the search

In the Find what text box, we can enter the value which we want to find in column B, which is “Product D”. As a result, the cell B6 is selected, as we can see in Figure 4.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc