A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drop Box Width



 
 
Thread Tools Display Modes
  #1  
Old February 1st, 2010, 06:51 PM posted to microsoft.public.excel.misc
JDH
external usenet poster
 
Posts: 9
Default Drop Box Width

I am having a weird behavior will my workbook! I have 5 columns in my
worksheets that contain a drop box for data validation. My question is, what
controls the width of the drop box? In one of my columns the drop box is
twice the width of the column when I click to open it. No matter how I adjust
the columns width, the drop box opens wider than the columns width. I am
using dynamic range cells for my data validation, and I have adjust the
columns width from that worksheet the match all the other worksheets. No sure
what to try next!

Any help would be appreciated!

JDH
  #2  
Old February 1st, 2010, 09:05 PM posted to microsoft.public.excel.misc
FloMM2
external usenet poster
 
Posts: 189
Default Drop Box Width

JDH,
If I understand you correctly, the drop down boxes is wider than the column
you are selecting iteems from a validation list.

That being said, try this:
Select a cell in the column with the drop down box. Do not make a selection
from list.
Select "Data" from the menubar.
Select "Validation".
In the "Source" section, you will find the source of your validation list.
Got to that column, resize as you desire.

hth
"JDH" wrote:

I am having a weird behavior will my workbook! I have 5 columns in my
worksheets that contain a drop box for data validation. My question is, what
controls the width of the drop box? In one of my columns the drop box is
twice the width of the column when I click to open it. No matter how I adjust
the columns width, the drop box opens wider than the columns width. I am
using dynamic range cells for my data validation, and I have adjust the
columns width from that worksheet the match all the other worksheets. No sure
what to try next!

Any help would be appreciated!

JDH

  #3  
Old February 1st, 2010, 11:06 PM posted to microsoft.public.excel.misc
JDH
external usenet poster
 
Posts: 9
Default Drop Box Width

Thanks for the reply,

Not sure I understand your post. When I go to DataValidationSource I have
(=NHTSA) for my "dynamic range" which is on another worksheet which the
column width is set at "4.14". If I go to DataValidationSource, how do I
resize the column from there? From the worksheet itself my column width is
set at "4.14" (the same as the worksheet of my data validation) but the drop
box list opens at a width of "10 to 13".

JDH

"FloMM2" wrote:

JDH,
If I understand you correctly, the drop down boxes is wider than the column
you are selecting iteems from a validation list.

That being said, try this:
Select a cell in the column with the drop down box. Do not make a selection
from list.
Select "Data" from the menubar.
Select "Validation".
In the "Source" section, you will find the source of your validation list.
Got to that column, resize as you desire.

hth
"JDH" wrote:

I am having a weird behavior will my workbook! I have 5 columns in my
worksheets that contain a drop box for data validation. My question is, what
controls the width of the drop box? In one of my columns the drop box is
twice the width of the column when I click to open it. No matter how I adjust
the columns width, the drop box opens wider than the columns width. I am
using dynamic range cells for my data validation, and I have adjust the
columns width from that worksheet the match all the other worksheets. No sure
what to try next!

Any help would be appreciated!

JDH

  #4  
Old February 16th, 2010, 05:37 PM posted to microsoft.public.excel.misc
Shiftless
external usenet poster
 
Posts: 1
Default Drop Box Width

This is not the solution. Re-sizing the source has absolutely no effect on
the width of the drop-down box.

"JDH" wrote:

Thanks for the reply,

Not sure I understand your post. When I go to DataValidationSource I have
(=NHTSA) for my "dynamic range" which is on another worksheet which the
column width is set at "4.14". If I go to DataValidationSource, how do I
resize the column from there? From the worksheet itself my column width is
set at "4.14" (the same as the worksheet of my data validation) but the drop
box list opens at a width of "10 to 13".

JDH

"FloMM2" wrote:

JDH,
If I understand you correctly, the drop down boxes is wider than the column
you are selecting iteems from a validation list.

That being said, try this:
Select a cell in the column with the drop down box. Do not make a selection
from list.
Select "Data" from the menubar.
Select "Validation".
In the "Source" section, you will find the source of your validation list.
Got to that column, resize as you desire.

hth
"JDH" wrote:

I am having a weird behavior will my workbook! I have 5 columns in my
worksheets that contain a drop box for data validation. My question is, what
controls the width of the drop box? In one of my columns the drop box is
twice the width of the column when I click to open it. No matter how I adjust
the columns width, the drop box opens wider than the columns width. I am
using dynamic range cells for my data validation, and I have adjust the
columns width from that worksheet the match all the other worksheets. No sure
what to try next!

Any help would be appreciated!

JDH

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.