software

I have created a number of drop down lists using Data Validation on one
spreadsheet. According to all the 'help' I've been able to find quot;The Data
Validation dropdown is the width of the cell that it's inquot;. Except that in
my spreadsheet it isn't.

All the dropdowns are wider than the cell (about 3 times as wide). They
work perfectly well but don't look good, overlapping adjacent columns and
being far wider than necessary to accommodate the required data.

Anyone know how I can change them so they are constrained by the width of
the cell? Any help would be great. Thanks
--
Ian

Go to Debra Dalgliesh's site amp; look for Data Validation amp; formatting in the
topics index

www.contextures.com/

quot;Ian3103quot; wrote:

gt; I have created a number of drop down lists using Data Validation on one
gt; spreadsheet. According to all the 'help' I've been able to find quot;The Data
gt; Validation dropdown is the width of the cell that it's inquot;. Except that in
gt; my spreadsheet it isn't.
gt;
gt; All the dropdowns are wider than the cell (about 3 times as wide). They
gt; work perfectly well but don't look good, overlapping adjacent columns and
gt; being far wider than necessary to accommodate the required data.
gt;
gt; Anyone know how I can change them so they are constrained by the width of
gt; the cell? Any help would be great. Thanks
gt; --
gt; Ian

And there's a bit of information he

www.contextures.com/xlDataValwidth.html

Duke Carey wrote:
gt; Go to Debra Dalgliesh's site amp; look for Data Validation amp; formatting in the
gt; topics index
gt;
gt; www.contextures.com/
gt;
gt; quot;Ian3103quot; wrote:
gt;
gt;
gt;gt;I have created a number of drop down lists using Data Validation on one
gt;gt;spreadsheet. According to all the 'help' I've been able to find quot;The Data
gt;gt;Validation dropdown is the width of the cell that it's inquot;. Except that in
gt;gt;my spreadsheet it isn't.
gt;gt;
gt;gt;All the dropdowns are wider than the cell (about 3 times as wide). They
gt;gt;work perfectly well but don't look good, overlapping adjacent columns and
gt;gt;being far wider than necessary to accommodate the required data.
gt;gt;
gt;gt;Anyone know how I can change them so they are constrained by the width of
gt;gt;the cell? Any help would be great. Thanks
gt;gt;--
gt;gt;Ian
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlI double checked the cell formatting and there were no merged cells in the
spreadsheet. I selected and the de-selected the merged cells option just to
make sure. I then tried inserting a blank column in between the cells with
data validation. And the same in the page containing the 'named ranges' that
feed the lists. And....it seems to have worked. I've saved the changes,
closed the file, and opened it again. And it still works.

I can't pretend I know why but many thanks for helping me get there.

Ian
--
Ianquot;Debra Dalgleishquot; wrote:

gt; And there's a bit of information he
gt;
gt; www.contextures.com/xlDataValwidth.html
gt;
gt; Duke Carey wrote:
gt; gt; Go to Debra Dalgliesh's site amp; look for Data Validation amp; formatting in the
gt; gt; topics index
gt; gt;
gt; gt; www.contextures.com/
gt; gt;
gt; gt; quot;Ian3103quot; wrote:
gt; gt;
gt; gt;
gt; gt;gt;I have created a number of drop down lists using Data Validation on one
gt; gt;gt;spreadsheet. According to all the 'help' I've been able to find quot;The Data
gt; gt;gt;Validation dropdown is the width of the cell that it's inquot;. Except that in
gt; gt;gt;my spreadsheet it isn't.
gt; gt;gt;
gt; gt;gt;All the dropdowns are wider than the cell (about 3 times as wide). They
gt; gt;gt;work perfectly well but don't look good, overlapping adjacent columns and
gt; gt;gt;being far wider than necessary to accommodate the required data.
gt; gt;gt;
gt; gt;gt;Anyone know how I can change them so they are constrained by the width of
gt; gt;gt;the cell? Any help would be great. Thanks
gt; gt;gt;--
gt; gt;gt;Ian
gt; gt;
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;