list in one cell

how can i ctreate a list in one cell such as drop down arrow
0
Utf
3/22/2010 9:26:03 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
606 Views

Similar Articles

[PageSpeed] 30

You can use data validation for this
http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=data+validation+excel



"sohail" wrote:

> how can i ctreate a list in one cell such as drop down arrow
0
Utf
3/22/2010 9:40:01 PM
hi
i think you are intersted in data validation.
on the tool bar>data>data validation.
also see this site for tutorial.
http://www.contextures.com/xlDataVal01.html

regards
FSt1

"sohail" wrote:

> how can i ctreate a list in one cell such as drop down arrow
0
Utf
3/22/2010 9:40:12 PM
Reply:

Similar Artilces:

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

splitting a single cell
Is it possible to split a single cell in Excel 2003? See your other post. "BK" <nospam@nospam.com> wrote in message news:%23QLbGI6oKHA.5696@TK2MSFTNGP04.phx.gbl... > Is it possible to split a single cell in Excel 2003? > ...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

how to prevent blank cell copied when combining cells?
I've tried to combine data from few cells using "CONCATENATE" function. But, when a cell is blank, a blank appears in the result. How to prevent this blank? please give sample to understand better "Vicneswari Murugan" wrote: > I've tried to combine data from few cells using "CONCATENATE" function. But, > when a cell is blank, a blank appears in the result. How to prevent this > blank? =if(a1="","",a1&" ")&if(b1="","",b1&" ")&c1 It kind of sounds like you were separ...

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

SMTP won't work, but OWA does for one user
I have a user whose mailbox exceeded the storage limits and Exchange "Closed" the account. They can log into the account via OWA, but when they try to login via Outlook over SMTP, it keeps prompting for username & password, and displays the following error: "There was a problem logging onto your mail server. Your Password was rejected. '-ERR Logon failure: unknown user name or bad password.', Port: 110, Secure(SSL): No, Server Error: 0x800CCC90, Error Number: 0x800CCC92" I tried to go into Active Directory to reenable the account, deleted mail from the ac...

#VALUE! error adding cells
I am trying to add a row of numbers contained in every other cell. This worked fine and I was able to copy the formula from one cell to the other. On the final cell, instead of adding the numbers, I am getting the message #VALUE!. I cannot figure out how to correct this problem. Check to see if you have a text value in one of the referenced cells - either actual text or a number that looks like text "Frustrated computer user" wrote: > I am trying to add a row of numbers contained in every other cell. This > worked fine and I was able to copy the formula from one ce...

Centre align if less than one line of text
I have set up my normal style to be justified, however if there is less than one complete line of text (no wrapping) I would like that paragraph to be centre aligned. Is this possible without having to do it manually each time? I imagine I am using Word for Mac 2008. many thanks for any help in advance. -- daved2424 No, you can't define a single style to work in different ways. Assuming you are talking about an actual 1 line paragraph rather than the last line of a multi-line paragraph you'd need to have a different Style or change the alignment directly. If ...

Auto response more than one time
Is there a way to set a rule in Outlook, using OutlookXP, that will send an auto response for each email received. It only sends out the auto response once per email address of the sender. Need it to go out for every email received. That is set at the Exchange Server and you will have a tough time getting the admin to change it since it causes loops of never ending Out of Office notifications. "Robert" <rsitarzewski@ci.bellevue.wa.us> wrote in message news:11bf01c3520a$0b698080$a001280a@phx.gbl... > Is there a way to set a rule in Outlook, using OutlookXP, > that wil...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Excel 2000
Hi Guys, This one should be simple for you guys! In Excel 2000, I have cells that are protected (Locked and Hidden). When I protect the sheet I use the UserInterfaceOnly option of the protect function. However I could not access the cell.formula even by code when the sheet is protected. Is this a normal behavior? And if so, Is there any workaround other than unprotected the sheet? Thanks, Lionel If you want to view the formula but protect the cell, do not check the "Hidden" checkbox when formatting the cell for protection. Be sure the "Locked" ch...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

How to line up the last cell in each row?
I have some data for which I am only interested in the final column from each row. The problem is that each row is a different length, so that row 1 may be 10 columns wide, row 2 15 columns, etc. How can I get the last element from each row to line up in the same column so that I can sort, sum, etc.? Here is one solution: Insert a new column at A1 so you now have shifted all of your data to the right. Assuming that Row 1 has headers your first data record will be in row 2. Type this formula into A2 =OFFSET(B2:IV2,0,COUNTA(B2:IV2)-1,1,1) Drag copy down to the end of your data. Column ...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

macro to check if cells have values in them...then
Hi - I am looking for a macro that will check 2 things....then do something. The first is if a range of cell values in are blank. lets say Sheets("Sheet1").Range("D6:G48"). Next is if a particular cell contains a given value , Sheets("sheet1").Range("E5") should equal "Year 1" if true. If both these are true then I want the macro to copy a range of cells from Sheets("Sheet2").Range("H6:H48") to Sheets("Sheet1").Range("D6:D48"). I tried to use IsEmpty but it seems to return a "False" if a...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Can data in one text box automatically appear in another?
I am trying to design a form in Publisher, and would like to link text boxes so that data entered in one will automatically appear in another on the same page. Is this feasible? How will this form be used? "G.O.G." <G.O.G.@discussions.microsoft.com> wrote in message = news:E4C951DF-7D4F-4FC1-8F6B-2C0B4EB8882A@microsoft.com... > I am trying to design a form in Publisher, and would like to link text = boxes=20 > so that data entered in one will automatically appear in another on = the same=20 > page. Is this feasible? Maybe with some programming... -- Mary Saue...

range specified by the value in another cell
I have the following problem: I have let say 100 numbers in column A, and a number n<100 in cell B1. I want to have the sum of the first n numbers in column A, so I would need to specifiy the range A1:An, but I need this independently of the actual value of n. I have tried A1:A(B1) with but it doesn't work. So has somebody any idea -- Message posted from http://www.ExcelForum.com Hi 2 ways for it 1. Use the formula =SUM(INDIRECT("A1:A"&B1)) 2. Create a named range RangeToSum=OFFSET(SheetName$A$1,,,SheetName!$B$1,1) The formula will be =SUM(RangeToSum) -- (When s...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...