Searching only one column in Excel

  • Thread starter Thread starter falcios
  • Start date Start date
F

falcios

How do I search only one column in Excel. I have highlighted the column and
did a Ctrl F and then tried a search but it doesn't work. Any other ideas of
what to do?

Thanks.
 
In the 'Find' toolbar, under options, make sure you select the option to
search withing "Sheet". Then you should be able to highlight the column you
want to search, and do what you want to do. If you select workbook, Find will
always look everywhere.
 

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

counting blank cells within two columns 2
Index/match across multiple columns? 19
Two search category & two search terms 4
Dragged 2 columns closer together, now can't see columns in betwee 2
Help! Text word search. 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to random pick a cell from more than one column 3
Excel sheet only displays last column 1

Back
Top