How to search data in one coloumn

G

Guest

Hi all,
My excel file consist of same type of data in various coloumns. I am
searching the data through Ctrl+f function in particular column but i have to
go through the various types of same data in other coloumn before reaching to
destination column.

Is there anyway, whereby i can search the data in particular one column only.

regards
gibbs
 
G

Guest

Select your column > ctrl F > Find what: "your criteria" > Options > Search:
select By Columns > Find Next
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to copare digits in two coloumn in Excel? 2
if functions 2
String Search 1
Lookup a coloumn and copy rows to a different sheet 1
Merge base on same code number 3
Function to seacrh for a word across multiple columns 2
del certain rows based on word search 2
How to change the format? 1

Top