Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
horizonal list
I would like to create a list on excel with no title. When the user selects
the autofilter, the pull down menu should only include info in the list. In addition I only want this to be on one cell. In other words instead on having verticle list, I would like to make the list horizonal Please Help this is my third post! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
horizonal list
"Steiner" wrote in message
... I would like to create a list on excel with no title. When the user selects the autofilter, the pull down menu should only include info in the list. In addition I only want this to be on one cell. In other words instead on having verticle list, I would like to make the list horizonal Please Help this is my third post! I think the reason you haven't received any replies before is that this cannot be done. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
horizonal list
Ok, but there must be a way to have a list, with no title. The issue is
that I would like to have a list on one cell only. So when someone clicks on the cell they make a selection out of the possible selections available. The selection appears on that cell. Currently with a list you need a header, you select the header than you view the list, you select an item in the list, and you are left with the header and the selection in the list. It ends up taking 2 cells, which makes the template messy. Thank you for your help "Stephen" wrote: "Steiner" wrote in message ... I would like to create a list on excel with no title. When the user selects the autofilter, the pull down menu should only include info in the list. In addition I only want this to be on one cell. In other words instead on having verticle list, I would like to make the list horizonal Please Help this is my third post! I think the reason you haven't received any replies before is that this cannot be done. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
horizonal list
Stephen is correct
The usual approach is to use a Data Validation drop-down list. Locally it only uses a single cell for the drop-down. The actual list of values is stored in a column of cells, but this column does not have to be "near" the body of the template. See: http://www.contextures.com/xlDataVal01.html -- Gary''s Student - gsnu200750 "Steiner" wrote: Ok, but there must be a way to have a list, with no title. The issue is that I would like to have a list on one cell only. So when someone clicks on the cell they make a selection out of the possible selections available. The selection appears on that cell. Currently with a list you need a header, you select the header than you view the list, you select an item in the list, and you are left with the header and the selection in the list. It ends up taking 2 cells, which makes the template messy. Thank you for your help "Stephen" wrote: "Steiner" wrote in message ... I would like to create a list on excel with no title. When the user selects the autofilter, the pull down menu should only include info in the list. In addition I only want this to be on one cell. In other words instead on having verticle list, I would like to make the list horizonal Please Help this is my third post! I think the reason you haven't received any replies before is that this cannot be done. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
horizonal list
Hi Steiner,
You don't need a header for a Data Validation dropdown list. For example, In say D4 to G4 put the values 1, 2, 3 & 4 Then select A1 Go to DataValidation Choose List from the dropdown And set the source data as =$D$4:$G$4 And OK out. Is that what you are looking for? Martin "Steiner" wrote in message ... Ok, but there must be a way to have a list, with no title. The issue is that I would like to have a list on one cell only. So when someone clicks on the cell they make a selection out of the possible selections available. The selection appears on that cell. Currently with a list you need a header, you select the header than you view the list, you select an item in the list, and you are left with the header and the selection in the list. It ends up taking 2 cells, which makes the template messy. Thank you for your help "Stephen" wrote: "Steiner" wrote in message ... I would like to create a list on excel with no title. When the user selects the autofilter, the pull down menu should only include info in the list. In addition I only want this to be on one cell. In other words instead on having verticle list, I would like to make the list horizonal Please Help this is my third post! I think the reason you haven't received any replies before is that this cannot be done. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
horizonal list
This is exactly what I was looking for.
Thank you "Gary''s Student" wrote: Stephen is correct The usual approach is to use a Data Validation drop-down list. Locally it only uses a single cell for the drop-down. The actual list of values is stored in a column of cells, but this column does not have to be "near" the body of the template. See: http://www.contextures.com/xlDataVal01.html -- Gary''s Student - gsnu200750 "Steiner" wrote: Ok, but there must be a way to have a list, with no title. The issue is that I would like to have a list on one cell only. So when someone clicks on the cell they make a selection out of the possible selections available. The selection appears on that cell. Currently with a list you need a header, you select the header than you view the list, you select an item in the list, and you are left with the header and the selection in the list. It ends up taking 2 cells, which makes the template messy. Thank you for your help "Stephen" wrote: "Steiner" wrote in message ... I would like to create a list on excel with no title. When the user selects the autofilter, the pull down menu should only include info in the list. In addition I only want this to be on one cell. In other words instead on having verticle list, I would like to make the list horizonal Please Help this is my third post! I think the reason you haven't received any replies before is that this cannot be done. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to rotate page 90 degrees to type horizonal | Charts and Charting in Excel | |||
add horizonal color coding to values | Charts and Charting in Excel | |||
validation list--list depends on the selection of first list | New Users to Excel | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) |