Using Find All

[skillsguy]

Hi. I want to use the find all feature of excel to select all the columns that it finds. Is this possible?

[martindwilson]

well ctr+a will highlight all the values found

[skillsguy]

unfortunately, ctrl+A does not select the columns

[FDibbins]

If you dont have a ton of items to find, you could use Conditional Formatting.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1="Word"

You could put "word" in it's own cell, then reference it

[martindwilson]

ctr+a wont select the column true but once done just chose a fill colour,hit enter then cells found will be filled with that colour its easy enough to see which columns have the same fill colour in them

[skillsguy]

Thanks for the help guys, but none of the methods suggest are quite what I am really after. I have a worksheet with columns that go, for example, A B C A B C A B C. I would like to select all the say C columns.

[FDibbins]

I have a worksheet with columns that go, for example, A B C A B C A B C.

Not really sure what you mean there? You can only have 1 column C, so do you mean you have more than 1 WS?

[skillsguy]

Sorry for being ambigious. I mean I have columns that have the names A B C A B C ...
i.e. column 1 has name A, column 2 has name B, column 3 has name C, column 4 has name D....

[FDibbins]

aahh ok. Might be easier to help if you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[skillsguy]

I attached a little example of what I want.