View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default How to search data in one coloumn

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

"gibbs" wrote:

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