| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sizing in Drop Down lists
I have attached drop down lists to a cell on my worksheet. The items in the
list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sizing in Drop Down lists
You have to widen the column.
-- Biff Microsoft Excel MVP "Banker" wrote in message ... I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sizing in Drop Down lists
Sorry T. Valko, When I pull up your response the screen is blank. Can you
please try again??? "Banker" wrote: I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sizing in Drop Down lists
You have to widen the column.
-- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sizing in Drop Down lists
I was hoping there was another way. Thanks for your response.
"T. Valko" wrote: You have to widen the column. -- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sizing in Drop Down lists
Debra Dalgleish has written event code to temporarily widen the column when
the DV dropdown is selected. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Column = 4 Then Target.Columns.ColumnWidth = 20 Else Columns(4).ColumnWidth = 8.43 End If End Sub Assumes DV dropdowns are in column D. If you want a specific or reduced range post back. This is sheet event code. Right-click on the sheet tab and "View Code" Copy/paste the above into that module. Alt + q to return to the Excel window. Gord Dibben MS Excel MVP On Wed, 17 Jun 2009 10:21:02 -0700, Banker wrote: I was hoping there was another way. Thanks for your response. "T. Valko" wrote: You have to widen the column. -- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sizing in Drop Down lists
Yes I found that same code on that website. Thanks for responding.
"Gord Dibben" wrote: Debra Dalgleish has written event code to temporarily widen the column when the DV dropdown is selected. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Column = 4 Then Target.Columns.ColumnWidth = 20 Else Columns(4).ColumnWidth = 8.43 End If End Sub Assumes DV dropdowns are in column D. If you want a specific or reduced range post back. This is sheet event code. Right-click on the sheet tab and "View Code" Copy/paste the above into that module. Alt + q to return to the Excel window. Gord Dibben MS Excel MVP On Wed, 17 Jun 2009 10:21:02 -0700, Banker wrote: I was hoping there was another way. Thanks for your response. "T. Valko" wrote: You have to widen the column. -- Biff Microsoft Excel MVP "Banker" wrote in message ... Sorry T. Valko, When I pull up your response the screen is blank. Can you please try again??? "Banker" wrote: I have attached drop down lists to a cell on my worksheet. The items in the list are wider than the cell that it will be viewed in. I know I can format the actual cell to wrap the text if it needs to for viewing after selected but how can I VIEW the entire width needed in the drop down list when I click on the arrow to choose the item I wish to show?? Basically I can only read about half of each of the items in the list. I hope this makes sense. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
| Drop Down list predicated on other drop down lists | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Linear Mode
