In the excel program, how do I create the dropdown arrows that allow for quick searches among entered data?

Question

I need help with two things:

1. How do I insert drop-down arrows so quick searches can take place within the excel document? An example of this: I am looking for 12 metres of fabric. By clicking on the arrow icon, I am able to see all entered data and click on "12" in order to narrow the search. I need help!

2. How do I make it so the drop-down arrows are always at the top of the excel sheet...for example, whether I am at #5 or #5,005, the #1 is always viewable for quick and easy access to entered data...?

Thanks for everyone's help!!
Sean

Answer 1

1) I believe the function you want for this is the Auto Filter. On the top menu bar, Data --> Filter --> Auto Filter.

2) To freeze the header row (I assume you want the header row), then select the row BELOW the one you want to freeze and then click on Window --> Freeze Panes

Answer 2

Well, I don't know if this is what you're talking about but I'm going to see if I can help anyway.

Enter the labels of the data you are going to use (i.e. Fabric#1, Fabric#2, etc.)

Select all of the labels and go to data => form and hit ok to the menu that pops up.

Start entering the data in the respective category by hitting new every time you need to add more items.

After entering all the data you can apply a filter by going to data => filter and select the auto filter option. (After you've applied the filter you can click on the arrow and it will give you different options and also the option to select a custom filter for your specific search).

Now, to make the drop down arrows always visible you can
go to the window menu => split and move the lines to the first row and then select the freeze panes option (Go to window menu, select freeze panes). That should allow you to scroll down and at the same time you would be able to see the first row.

Answer 3

I dont know if that is possible in Excel. Sounds like you should be using Access for this application.