How to select multiple specific cells in excel at once?

Question

Say there are 3 columns with 3000 rows filled with data. In the second column are a bunch of numbers. Some of these numbers are repeated. Lets pretend I need to select all the number 11's ENTIRE ROW at once. Is there a method for selecting the whole rows as long as they contain the number 11 in them? Right now I've been selecting each row individually and it takes FOREVER...please help!

Answer 1

If you would rather not sort your data, you can use the filter option.



1) Click on the heading for your second column

2) Data - Filter - Autofilter

3) click the little down arrow and pick 11 -> all the rows with 11 will be displayed, and all the other rows hidden

4) if you select these rows, only the displayed rows will be selected, the hidden ones will not.



If you need additional info, pls. add detail or e-mail.

Good luck!

.

Answer 2

sort the fields you want to use, so if you have fields with numbers sort that column which will group all the "11s" together, then select the group by draging the mouse from top to bottom or select the first row, hold shift and select the last row

Answer 3

Sort the whole table by that column. It puts them all together and makes them easier to select.



If you need to put the table back in the same order, first add a column with unique numbers to identify the original order (an ID column 1,2,3,4,etc.)



Sort using Data->Sort

Answer 4

This can be tricky. A client may wish to select colors first before choosing paper weight. With drop down boxes you are assuming logical choice where one choice opens to another in a linear sequence. I would suggest you create a simple list with all the attributes in columns. You or your client can click the attributes and the filtered list will show what is available.

Answer 5

Would this work?

Select the row

Go to edit, find

Find all

Answer 6

If you hold in the CTRL key then drag your mouse across the cells you want.