Question about Microsoft Excel for PC

1 Answer

Search options in drop down menu

I am creating a drop down menu for 1000 items and would like to put the item number and get the pricing for that particular item rather than scrolling down the drop down box. Is it possible?

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 58 Answers

It is possible. But you need to write a macro to map the selected item number to price.

Posted on Jan 31, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Set homepage


Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help

Click on the tools at the bottom of the drop down list will be internet options or
Click start control panel internet options you will see a home page box To Create Page Tabs type

each adress on its own line (type in www.google.com) or your preferred home page and browser
below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them.

Here is another option to add

Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items.

Jan 05, 2014 | Computers & Internet

Tip

How to put a reserve price in your ebay listing



Here's how you can put a reserve price in your listing, follow these steps:
First, if you are lisitng an item using the Simple Form you need to switch to form with more choices first. In the Create your listing form please click the "Switch to form with more choices" link that you will see on the upper right hand corner of the Create Your Listing page. Then follow the steps below:
1. On Create your listing/Edit your listing page, scroll down and look for "Choose how you'd like to sell your item" section on yellow orange background.
2. Click on "Add or remove options" link within the same section.
3. Click "Set a minimum selling price for your item" for Reserve price and the "Save" button after.
4. This will appear: "No Reserve price set for this item. Change"
5. Click on Change to put a Reserve Price. Then click on Save button.

on Dec 31, 2009 | Computers & Internet

1 Answer

Set homepage


Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help

Click on the tools at the bottom of the drop down list will be internet options or
Click start control panel internet options you will see a home page box To Create Page Tabs type

each adress on its own line (type in www.google.com) or your preferred home page and browser
below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them.

Here is another option to add

Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items.

Dec 27, 2013 | Computers & Internet

1 Answer

Set homepage


Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help

Click on the tools at the bottom of the drop down list will be internet options or
Click start control panel internet options you will see a home page box To Create Page Tabs type

each adress on its own line (type in google.com) or your preferred home page and browser
below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them.

Here is another option to add

Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items.

Dec 17, 2013 | Computers & Internet

1 Answer

Set homepage


Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Click on the tools at the bottom of the drop down list will be internet options or
Click start control panel internet options you will see a home page box To Create Page Tabs type
each adress on its own line (type in google.com) or your preferred home page and browser
below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them.
Here is another option to add
Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items.

Nov 18, 2013 | Computers & Internet

1 Answer

I put google as my homepage but when i click to go


Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Click on the tools at the bottom of the drop down list will be internet options or
Click start control panel internet options you will see a home page box To Create Page Tabs type
each adress on its own line (type in google.com)
or your preferred home page and browser
below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them.
Here is another option to add
Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items.

Sep 15, 2013 | Computers & Internet

1 Answer

Make google my homepage


Create the menu tab on your homepage right click in the top toolbar you should see a number of toolbar options select the menu tab which will add File Edit View Favorites Tools and Help
Click on the tools at the bottom of the drop down list will be internet options or
Click start control panel internet options you will see a home page box To Create Page Tabs type
each adress on its own line (type in google.com)
or your preferred home page and browser
below that will be change search defaults click on settings you will see all search Providers
Toolbar extensions and Accelerators you have if don't need any of them you can disable or remove them.
Here is another option to add
Right click in the bottom toolbar (Bottom of Screen) select the toolbars option then Desktop this will add >> arrows in the bottom toolbar select the arrows you will see a list with control panel which has another list of all control panel items

Sep 04, 2013 | Computers & Internet

1 Answer

I have listed something on Ebay and it doesnt give me the option to put a reserve price


Here's how you can put a reserve price in your listing, follow these steps:
First, if you are lisitng an item using the Simple Form you need to switch to form with more choices first. In the Create your listing form please click the "Switch to form with more choices" link that you will see on the upper right hand corner of the Create Your Listing page. Then follow the steps below:
1. On Create your listing/Edit your listing page, scroll down and look for "Choose how you'd like to sell your item" section on yellow orange background.
2. Click on "Add or remove options" link within the same section.
3. Click "Set a minimum selling price for your item" for Reserve price and the "Save" button after.
4. This will appear: "No Reserve price set for this item. Change"
5. Click on Change to put a Reserve Price. Then click on Save button.

cheers!

Oct 03, 2009 | eBay Auctions

1 Answer

I WANT THE WHOLE CODE FOR THIS


This whole code for above we can not give.

Aug 06, 2009 | Shopnovell iFolder 1.0 Software Media Kit...

2 Answers

My desktop shortcuts open with search results page only


1.
Right-click Start, and then click Explore.
2.
Locate the folder, file, or program in the Folders directory, and then click the item to open it.
3.
Click the icon representing the item.
4.
Click File on the toolbar, and then Create Shortcut on the drop-down menu that appears.
5.
Right-click on the shortcut icon that is created.
6.
Choose Send To from the drop-down menu, and then click Desktop (create shortcut) on the submenu that appears.

Jan 09, 2009 | Acer Aspire™ T180 PC Desktop

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

127 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2885 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18408 Answers

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

Answer questions

Manuals & User Guides

Loading...