Question about Microsoft Excel Computers & Internet

1 Answer

How do I make a drop down list searchable in excel?

Posted by Anonymous on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 252 Answers

Hello Anonymous

Refer to the following video for a complete step by step tutorial on how to create a searchable drop down list in excel. This will work with Excel version 2007 and above



If you need any further assistance, let me know.

Thanks

Posted on Aug 10, 2015

Ad

2 Suggested Answers

6ya6ya

6ya staff

  • 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad
efs_perpends

efs_perpends

  • 1996 Answers

SOURCE: Why do i loose my custom Views in Excell 2003 when

Have you tried to save them as a custom worksheet template? See this tip , this one, this tip, and site for other tips related. (For saving custom views of filtering criteria, see here and here.)
Here is the MS article that thoroughly explains the means for using VBA codes to customize your excel 2003 command bars.

I hope this information allows you to resolve this issue. If you need further assistance, please post back with a comment to this thread.
If I've managed to answer your question or solve a problem, please take just a moment to rate this post....thanks!


Posted on Aug 26, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Have multiple select drop down list via vba code in excel 2013. Works great until i protect sheet then only single entry allowed. Can you help? Thanks


Randy
have a look at this forum answer below
https://stackoverflow.com/questions/30717304/excel-protected-sheet-drop-down-box-to-access-macro-error?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

Apr 23, 2018 | VIA Computers & Internet

Tip

Excel - Drop Down List Ever wish that you didn't have to type...





Excel - Drop Down List

Ever wish that you didn't have to type out the same thing over and over again? Well you can save time by using Excel's drop down list!


Drop Down Preparation

Imagine that we are creating an Excel spreadsheet to document our purchases from the grocery store. For each purchase we want to mark down the name of the food and the type of the food.
The way a drop down list works in Excel is that it takes values from some place on your spreadsheet and uses them to populate the options in the list. Lucky for us, the type of food is a perfect opportunity to use a drop down list!
In cells A1 through A7 enter the type of food that will be used for the drop down list.


Creating a Drop Down List

Now that we have a source for our drop down list, we can create a begin to create our drop down.
1. Select cells D2 though D20 (We will be creating a drown down list for each cell in this range)

2. Click the Data menu and select Validation
3. Choose List from the Allow drop down menu

4. Click the Source button that appears to the right of the textfield

5. Select our source cells A1 though A7

6. Press Enter and Click OK

Testing Your Drop Down

All of your cells in the Type column should now have a drop down list. To test to see if your drop down works, click on cell D2 and then click on the downward facing arrow and see if all the types of food are available.

on Nov 19, 2013 | Microsoft Excel Computers & Internet

2 Answers

Cant get the Indian rupee format in EXCEL.


there is a popular solution for those who have been locked out by excel spreadsheet. For this solution, what you need is a password recovery tool,Google Excel Password Recovery 5.0 for password recovery. Download and install the software.
With Excel Password Recovery 5.0, you can open you excel spreadsheet without data lost.

Sep 14, 2010 | Microsoft Excel for PC

1 Answer

What is formula to use 5 point drop down list to prompt entry of cell value into specific location


You can use cell validation.
Select the cells you want to have the dropdown list.
Press the following keys "alt" "d" "l" and you get a message box.
select List from the drop down.
Now you can type in your list in the blank box separated by commas

Nov 29, 2009 | Microsoft Excel for PC

1 Answer

Excel-template


Open a blank workbook in Excel and click "save as" option select "Template" from the drop-down list and save it

Hope this helps,

CynosureboY

Sep 13, 2008 | Microsoft Excel for PC

1 Answer

Excel


Hey dude,

Select both the columns and click on Auto-filter option. This will give you a drop-down list box to select data of your choice.

Sep 06, 2008 | Computers & Internet

1 Answer

Excel


Would you not be better off with a pivot table ?

To use multiple drop downs - each listing would need to be associated, or have a column that causes a relationship.
When selection 1 is made - a formula will dictate what fields to make visible (available) in the next menu..
you could build a macro in that will 'lift' the formulised data, and 'paste as values' it into a control area that will then give you a definitve second list based purely on the initial drop down.

Hope this makes sense

Aug 12, 2008 | Microsoft Excel for PC

1 Answer

Drop Down Menus


Click on Data (Top menu), Choose Filter from the drop down list, Choose Auto filter from the shown list. Now you get filter list on each column. Choose the filter condition on the column(s) you want and the data get filtered based on the condition you have given.


Fixya?

Feb 28, 2008 | Microsoft Excel for PC

1 Answer

DropDown menus in Excel


The quickest and easiest way is to go to the data menu and choose filter and then autofilter. This will allow drop downs on all columns which can be picked to filter one or more columns. Custom in the drop down list will give you further options.

Feb 27, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

98 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

Alun Cox

Level 3 Expert

2679 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...