How to select all cells containing a certain word?

N

Name4222017-04-18 21:46:54

excel

Name422, 2017-04-18 21:46:54

Let's say there are cells in a huge table that contain the word "ball".
How to select all cells containing the word "ball"?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Artem, 2017-04-18
@devspec

Ctrl-F - enter "ball" - button "Find all"
In the list that appears at the bottom of the search box - Ctrl-A
Well, or just use the text filter.

Similar questions

S

Sergey Dydaevskiy2017-10-18 12:01:52

K

kiddle2017-10-20 02:39:11

A

AbarKhali2020-03-06 22:59:32

P

Pavel2017-10-24 10:44:32

J

Jiy52017-10-24 20:46:40

Didn't find what you were looking for?