How do you do something similar to queries but on EXCEL not Access?

Question

I'm sure it's possible because I've seen it being done and you choose from a drop-down menu but I can't remember the technique. Thanks in advance.

Nope filters does not do it for me, I'm not even sure what it has done. :-S

Nope none of the first 4 questions have helped me
(sorry guys- no offence). I really only want to choose from a drop-down menu on my actual data like in iTunes when you type in a word in the search section and it only finds songs with that word in it.

Okay, so maybe filters do do it for me, but I just probably wasn't using them right. Many thanks to TheHumbleOne. =D

Answer 1

Go to Tools --> Filters and choose Advanced Filters.

Answer 2

I don't understand why filters "does not do it for you." I use this all the time.

click the Table-select button to the left of A, and above #1.
This will select the whole file.
click Tools
click Autofilter
You will see a down arrow on each column
click the down-arrow on the column you want, then select the criteria

You can also filter, refilter, etc until you end up with what you want.

You could also create a "custom" filter by choosing that option. You can create a custom filter and sort.
What more do you want?

When finished, turn the filter off by clicking Tools, click Autofilter.

Answer 3

From the tool bar go into Data/Import External Data/New Database query. This opens Microsoft Query. You can then either choose to run the wizard or not. (I choose not to use the wizard) you can then choose tables as in access. You can query from access tables or another excel workbook or several other data sources. I use it all the time.

Answer 4

What you want to do is enable filters from the data menu

Answer 5

You could setup an ODBC datasource to your excel spreadsheet this woud allow you to run SQL statements against your spreadsheet using Access or MSQuery32.

Answer 6

You could use "Find" from the Edit menu, if I understand your question correctly.