Question about Microsoft Excel for PC

2 Answers

Excel-formula Connect two drop down menues When selection is made in the first, make certain items available in the second

Posted by on

2 Answers

Vlookup

Posted on Aug 29, 2008

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to protect some cells on excel sheet
Dipak

Posted on Aug 25, 2008

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I replace formulas in excel on mac computers with the value derived from the formula


Select the cells you want to convert. Then go to the menu edit/copy (command-C). Then select from the menu edit, paste special, and select the radio button "values".

This will overwrite the formulas with values. If you want to keep t he formulas, then paste the values in a different location.

These commands are available from the keyboard, the edit menu, and also from the right-click menu.

May 12, 2014 | Super Probiotic 30 caps Special Formulas

Tip

How can I create a Barcode for Free in Microsoft Excel?


<p>Placing barcode equipment or other things makes it easier to keep track of them. Instead of entering a long number, a quick scan with a bar code reader eliminates keystrokes. There are many different types of barcodes. The most famous is the Product Code or UPC Universal, in almost all items sold at retail in the United States. The UPC format only supports encryption of the songs. Other formats such as Code 39 (also known as Code 3 of 9) support letters and numbers. <br /> <p><br /> <p>1. Find a free TrueType font to the desired shape of the bar code. For example, the Code bar code format is 39 different TrueType font packages available free. Use an Internet search engine and type "Code 39 TrueType fonts" available in a free font found. Some specialized formats may not be available for free as a result of copyright or other restrictions. <br /> <p><br /> <p>2. On your Windows PC, select the Start menu and click Control Panel. Within the Control Panel, click Switch to Classic View "and appearance of the panel. Find the" Fonts "icon and double click to open it. On the File menu, select" Install New Font. "This opens a menu dialog asking you to change the font to install. Navigate to the folder that contains the downloaded TrueType font file. Select the font and click OK when prompted to install it. The source of new bar code will be available in Excel. <br /> <p><br /> <p>3. Start Excel and enter "98765" in cell A1. This value is converted to a bar. <br /> <p><br /> <p>4. In cell B1, type the following formula: "= CONCATENATE ("*", "*")" A1 and press enter. The result should be "* 98765 *". Code 39 format requires an asterisk at the beginning and end of the text to be encrypted. Bar code format other will have different rules. <br /> <p><br /> <p>5. Change the font in cell A1, choosing a different font from the drop-down menu at the top of the screen in Excel. Under the menu "Home", scroll down to "three of the nine free" source and select it. The text in the cell will now appear as a barcode. Increase font with a minimum of 28 points, so a scanner can pick up the scanning needs. <br />

on Jun 26, 2011 | Computers & Internet

1 Answer

Search options in drop down menu


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

Jan 26, 2009 | Microsoft Excel for PC

1 Answer

Need a formula for excel


select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

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

1 Answer

Asking Excel to insert a drop down list based on previously entered text


Yes...no....yes....and yes. And if that sounds like a funny response let me explain. First of all you can write a formula for a specific cell (or cells or interrelated cells where you menus would display). It takes a while and if you are new to the syntax it could take a couple hours even (let's assume you are not a math major). Using Access, for something this apparently simple, I would not suggest (another learning curve but admittedly a reasonably easy one). But, this is the second yes, the easiest way to do this would be to simply insert a "comment". When you hold the cursor over the cell...your data...i.e. menu...will pop up. And yes...(last yes) you could have Sunday thru Monday across the top and Breakfast, lunch and dinner in the right hand column. Now this assumes what you have said is what your are trying to do...effectively meal planning...and you are not trying to plug in the inventory in the fridge to develop a shopping list.

Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.

Feb 04, 2008 | Microsoft Excel for PC

2 Answers

EXCEL


It is very useful to learn excel shortcut realy i thank you

Sep 26, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

57 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...