Excel experts: how do I make this kind of a dropdown list (details inside)?

Excel experts: how do I make this kind of a dropdown list (details inside)?
by

1 Answer

Answer :

while in Excel, hit F1 key. Type in drop down. This is the MS help function to get you there
by

Related questions

Computer experts I need your help! (more details inside)

Description : Computer experts I need your help! (more details inside)

Last Answer : answer:Bad memory (RAM) or a bad chip on the graphics card. Give more information: How much memory is it supposed to have? How much memory does it say it detects? Go into device manager ( ... pushed all the way into the angled slots. Somewhere you have a memory problem. The question is: where.

Can't get rid of acne problem at all , details inside ? Bron problem for almost two years. The skin has become black due to the brown spots. I have taken various treatments at different times to solve this problem but it did not work . The skin has started to be free of acne. I will use any face wash to keep my skin acne free , oily free and clean. Experts suggest that. With the name , price and detailed information of face wash. I waited for the answer. Note: I am 16 years old, thank you in advance ,,,,,,,,,

Description : Can't get rid of acne problem at all , details inside ? Bron problem for almost two years. The skin has become black due to the brown spots. I have taken various treatments at different times to solve this problem ... I waited for the answer. Note: I am 16 years old, thank you in advance ,,,,,,,,,

Last Answer : : You can use Assure facewash for your problem . And the price of facewash is not known. However, it seems to be between 250 to 300 rupees.

Can I select dropdown menus via keyboard in OSX?

Description : Can I select dropdown menus via keyboard in OSX?

Last Answer : System Preferences—> Keyboard and Mouse—> Keyboard Shortcuts At the bottom select “All Controls” under “Full keyboard access”. Edit to add : This also makes it so tabbing will select other elements on the page. (like links) Control + F7 will turn this on and off.

CSS dropdown menu crisis with IE 7...

Description : CSS dropdown menu crisis with IE 7...

Last Answer : Your first problem is that you've defined the .clearfix CSS class in the HEAD of your document but you have not applied it to any of the elements in the BODY. The page where you ... containing a float needing to be cleared, plus any Guillotine-Bug-fixing block elements within the container."

How to create a dropdown button for navbar menu ? -How To ?

Description : How to create a dropdown button for navbar menu ? -How To ?

Last Answer : Example Explained. Use any element to open the dropdown menu, e.g. a , or element. Use a container element (like ) to create the dropdown menu and add the dropdown links inside it. Wrap a element around the button and the to position the dropdown menu correctly with CSS.

how to create a split button dropdown with CSS. ? -How To ?

Description : how to create a split button dropdown with CSS. ? -How To ?

Last Answer : answer:

Any video card experts out there? (see details for problem)

Description : Any video card experts out there? (see details for problem)

Last Answer : The ATI control panel tools don’t let you select which card should be primary?

How do I do this in Excel? (please see details inside)

Description : How do I do this in Excel? (please see details inside)

Last Answer : I don't have it in front of me, but I'm seeing 0 answers so far, so maybe get you started. I think the easiest way to do this is with conditional formatting , which is pretty simple to use, but I' ... NO as well) and whitespace (require no to be the complete cell). Hope it helps get you going.

Dog is scared of people- can any behavior experts give me advice? (see details)

Description : Dog is scared of people- can any behavior experts give me advice? (see details)

Last Answer : I have a 2 year old schnauzer, we bought him a few months after he was born and he is the EXACT same way. He is a fearful dog, and we kind of just accepted that, so long as he seems ... you can really help her improve. Here is a website that might help!--> http://www.fearfuldogs.com/index.html

Computer Experts: Please help me this issue with prl_disp_service.

Description : Computer Experts: Please help me this issue with prl_disp_service.

Last Answer : Sorry about the typo in the question title… my bad. It should be “Please help me with this issue…” (if a mod can fix that for me and then delete this post, that would be great)

Windows 7 experts - a video card question?

Description : Windows 7 experts - a video card question?

Last Answer : answer:Have you tried swapping your gpu’s into opposing pcie slots on your motherboard? Your Bios maybe detecting the 2250 as primary and win7 is just playing along.

Computer experts - how do I remove this "trojan"?

Description : Computer experts - how do I remove this "trojan"?

Last Answer : The only way to get rid of a trojan (in my experience) is to completely wipe the hard drive (e.g., format). But, I’ve lived with trojans for a few years… they never seemed to hurt any of my files or internet connection.

Any computer experts out there? (Do you build them, fix them, know the quality of them?)

Description : Any computer experts out there? (Do you build them, fix them, know the quality of them?)

Last Answer : It won't void the warranty, but you won't be able to get tech support from the computer vendor on an OS you install yourself. Vista's principal issues were: understated hardware requirements for ... you need a Microsoft OS around because it makes some things easier (I mean besides getting malware).

Vista Task Scheduler Experts - I can't get the program "Tray Status" to run automatically.

Description : Vista Task Scheduler Experts - I can't get the program "Tray Status" to run automatically.

Last Answer : I don't really know Windows. But TrayStatus.exe isn't really telling it where the file is. Try a complete path or cd into into the directory the file is in before running the command. Example: Microsoft ... (s) 0 bytes 2 Dir(s) 5,222,629,376 bytes free C:\Documents and Settings\johnpowell\Desktop>

What kind of qualifications do H&R Block tax advisor experts have?

Description : What kind of qualifications do H&R Block tax advisor experts have?

Last Answer : H&R Block tax advisor experts have to graduate from a four year certifed university or college. In addition , most if not all of them have a either a master degree in fianace or a MBA.

How can I make this conditional formatting rule in Excel?

Description : How can I make this conditional formatting rule in Excel?

Last Answer : answer:Conditional formatting isn't too difficult, but the interface is unusual (not like other Excel interfaces), so that takes some getting used to. Assuming you know how to access the commands via the menu, I'll ... to a number of cells in B:B. You'll get it if you just keep playing with it.

How to make columns into lists for .csv (excel) with Python?

Description : How to make columns into lists for .csv (excel) with Python?

Last Answer : answer:data = open( grades.csv , r ).readlines() for line in data: [t]items = line.split() [t]print items[0], items[2] note that Fluther strips the required tabbing from the program, replace [ ... to delimit columns. Should really close the file in the program and not leave the OS to sort it out.

Techno Jellies, what do you make of this? [details inside]?

Description : Techno Jellies, what do you make of this? [details inside]?

Last Answer : LCD screens require a backlight. Quite often, particularly on older screens, this is basically the equivalent of a fluorescent tube. Sounds to me like the tube has failed.

Help with an Excel question, I want to center the page on screen?

Description : Help with an Excel question, I want to center the page on screen?

Last Answer : Well, first, in the view tab, uncheck all of the grid lines, formula bars, ruler and headings. Is that more like what you're looking for? Protecting is kind of clunky. First highlight the cells you want to ... It should open up like that for people you send it to. You can practice on me if you want.

Why don't the links work in the Excel work book I emailed?

Description : Why don't the links work in the Excel work book I emailed?

Last Answer : They (links and macros) are on your hard-drive and not part of the attachment, you emailed .

Why do people look at me in such surprise when I tell them I know Word, Excel, Powerpoint, etc?

Description : Why do people look at me in such surprise when I tell them I know Word, Excel, Powerpoint, etc?

Last Answer : You could have written an IF function that automatically enters “Plastic” if it finds “BM”, “BR”, and “IB”, and then paste that function into every cell of the column.

Can you tell me how to do this in Excel?

Description : Can you tell me how to do this in Excel?

Last Answer : answer:Oh hail yes, I figured it out all by my self. Thanks for the HELP!

Is it true you can't send a single tab from excel in an email?

Description : Is it true you can't send a single tab from excel in an email?

Last Answer : I really think the easiest way would be to use a PDF printer driver like Cute PDF Writer to print that one sheet. By design, it really isn't any more of a hassle than printing it out ... different printer ), and partly for compatibility, as they work with any program that has a Print option.

Can you recommend a good book for learning Excel programming and macros?

Description : Can you recommend a good book for learning Excel programming and macros?

Last Answer : answer:Yes, (at least in Office 2010), VBA is still part of the installation package, and highly useful. I would suggest that you start to learn coding on your own, before buying a book ... advice about books, other websites, and even some of the Microsoft MVP websites that many of them maintain.

Do you have a solution for this problem concerning Excel?

Description : Do you have a solution for this problem concerning Excel?

Last Answer : answer:Use the same excel data base saved as a different file with the new year and simply have the person search for their name, and then mark an X in a new column titled Present 2013 ... of elimination) and also will identify anyone attending for the first time. Hope this is helpful somehow.

Is it possible to change the icon on a a saved Excel or Word file?

Description : Is it possible to change the icon on a a saved Excel or Word file?

Last Answer : answer:If you change the extension to something other than one that Windows knows and already associates with Excel, including: .xls .xlsx .xlsm .xlt & etc. then you'll have to make a manual association ... which recognizes the .dxls file type, and still tell it to open with Excel.) Just do it.

Do you know Excel?

Description : Do you know Excel?

Last Answer : Yes, I’ve regularly used Excel for many years. If you ask your question, I’ll be happy to try to answer it.

How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?

Description : How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?

Last Answer : I wonder if the fact that the cells I’m trying to leave unlocked are merged is part of what is creating this problem…?

How else can you correlate data on Excel?

Description : How else can you correlate data on Excel?

Last Answer : Can the data be paired, as in, do you have readings from both machines on the same samples? If yes then yo can plot the dat using Y vs X where Y is the new machine and X is the old. For ... with smooth lines. You now have your chart. Now play with the other options to make it pretty. Good luck.

How do I set defaults in excel?

Description : How do I set defaults in excel?

Last Answer : answer:You can save your tweaked in chart as default chart type; you need to save it as a custom chart type. To do that, follow these steps: 1. Create the chart that you want to use (your tweaked ... this helps (since it's Excel 2003, otherwise you can refer to this post). And here is another link.

Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Description : Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Last Answer : From what I’ve gathered, Vista and 7 don’t have any.

How to export search results from Microsoft Excel?

Description : How to export search results from Microsoft Excel?

Last Answer : answer:If you highlight the labels at the top of each column, then click on the data tab, and the big filter button.. you'll be able to sort out which ones are from New Jersey. ( ... paste those into a new spreadsheet. Without actually seeing an example of your spreadsheet this is my best guess.

Excel conversion functions?

Description : Excel conversion functions?

Last Answer : answer:I am not aware of an off-the-shelf solution. Hopefully someone has an easier way, but here's how I approach the question: 1) The INT function will give you the whole number (41) =INT(41 ... fractions-in-excel.php Sorry to give an incomplete answer, but that's all I have time for this morning.

Why does Microsoft Excel do this with graphs and how can I fix it?

Description : Why does Microsoft Excel do this with graphs and how can I fix it?

Last Answer : Can you e-mail me the file? I will play with it. You should know my e-mail Inverted Treestump..

Microsoft Excel for Mac 2001?

Description : Microsoft Excel for Mac 2001?

Last Answer : You might try uninstalling the program, uninstalling Office and then reinstalling it.

In Microsoft Word - how do I paste Excel spreadsheets properly?

Description : In Microsoft Word - how do I paste Excel spreadsheets properly?

Last Answer : I usually open a text box in word, then highlight the cells in the spreadsheet that I want to paste into the text box, and paste the cells into the text box.

How can I automate this series of actions in excel?

Description : How can I automate this series of actions in excel?

Last Answer : I just had one idea. There are two main problems here: 1) How to get the thing to identify successive 12-line sections of cells. Maybe if I use the cut function instead of the copy function it will ... are inelegant, but might work. As you can tell, I'm a newbie at automation. Any better ideas?

What should I use for statistical analysis on Excel 2008 MAC?

Description : What should I use for statistical analysis on Excel 2008 MAC?

Last Answer : Try SPSS. A quick Google search indicates that it’s available for Mac.

Is this dataset too big for Excel to handle?

Description : Is this dataset too big for Excel to handle?

Last Answer : It sounds like your limit is your CPU, not Excel.

How do I insert an excel sheet into a word document VERTICALLY?

Description : How do I insert an excel sheet into a word document VERTICALLY?

Last Answer : Does the spreadsheet have to be a spreadsheet when you paste it? That is, does it need to retain its usability as a spreadsheet ? Because if it doesn't, I'd suggest just pasting screenshots of it, ... that way, too, since you wouldn't be copying the source file, but just .JPG views of it.

How do I automatically add the date to a MS Excel cell?

Description : How do I automatically add the date to a MS Excel cell?

Last Answer : You would want a macro, or if you hit Ctrl+; it automatically puts in the current date in the selected cell, and you can add the called left message afterward If you want to do a macro, you can record ... need to edit the macro to work for each line. So it might be easier to use the Ctrl+; shortcut

Excel Masters: Results from search engine magically transported to excel? Is this possible?

Description : Excel Masters: Results from search engine magically transported to excel? Is this possible?

Last Answer : I’m not claiming to be an Excel expert, but it is not clear to me what your source data is in this case. Is the data on a website in HTML, or are you entering queries in Google and need to copy out those results?

Microsoft Excel Question?

Description : Microsoft Excel Question?

Last Answer : Not that I know of. However, what I would do instead is link to the folder, without the file name, since you are updating the folder contents. Then the link will always go to a view of what’s in the folder. (It is one more step for users when following the link, though.)

Export Shapefiles to Excel

Description : Export Shapefiles to Excel

Last Answer : answer:Which formats are available for export from the application? srm

Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Description : Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Last Answer : Yes, but the software would depend on where/how the email addresses are currently stored.

How do you apply a linear curve fit in MS Excel?

Description : How do you apply a linear curve fit in MS Excel?

Last Answer : answer:Right click on one of the data points. Add Trendline… Select Linear for Trendline Regression Type Close A linear trend line should appear. (Excel 2010)

How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Description : How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Last Answer : answer:This is a really clunky solution. In numbers select File -> Export -> Save as PDF. Then you can open that PDF and copy and paste into Pages and it will lose the formating. I wish I knew of a better way. I have been trying for about 20 minutes and that is the best I could come up with.

Help: My Microsoft Excel "Paste Special// skip blanks" feature isn't working!

Description : Help: My Microsoft Excel "Paste Special// skip blanks" feature isn't working!

Last Answer : this is probably stupid and fairly obvious, but did you try rebooting your Excel and/or your computer? And when you say the feature isn't working, I assume you mean you check the box for it and ... command? Also, did you try using a brand new spreadsheet and see if the feature is working in that?

In Excel, have you have ever had this problem with the cursor keys?

Description : In Excel, have you have ever had this problem with the cursor keys?

Last Answer : answer:The whole screen?! Like the desktop and everything… basically all lit pixels? Or do you mean the whole Excel window?

Where is Excel installed on my PC?

Description : Where is Excel installed on my PC?

Last Answer : Should be in your local disk (C:), under programs and in the microsoft office folder.