Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default Searching only one column in Excel

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default Searching only one column in Excel

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"falcios" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for strings in a column [email protected] Excel Worksheet Functions 6 January 23rd 09 06:20 PM
Searching up a column Mike Rogers[_2_] Excel Discussion (Misc queries) 7 December 31st 07 03:46 PM
Searching One Column Only [email protected] Excel Discussion (Misc queries) 2 August 31st 06 12:17 PM
Searching for Duplicate Text in a column acesandspades101 Excel Worksheet Functions 2 August 25th 06 12:40 AM
Column searching problem mikeyts New Users to Excel 2 December 18th 04 09:35 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"