Drop menu width

G

gta1216

Board Regular
Joined
Apr 23, 2016
Messages
63
Is it possible to make the dropdown menu (data validation) wider than the width of the column? One if my column is 60 pixels but I would like the dropdown menu to Be possibly 200 pixels wide. Is that possible?
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
Have a look at Debra Dalglieshs site here, about 3 quarters the way down the page, at the heading....."Make the Dropdown List Temporarily Wider"

www.contextures.com

Excel Data Validation Tips and Troubleshooting

How to fix Excel data validation problems. Drop down not working, blank selected, not showing all data. Videos, written steps, data validation troubleshooting
www.contextures.com

But I don't think you'll do much better than that.....
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Solved
Button to Switch between two values on a data validation dropdown list
Replies
6
Views
255
Peter_SSs
Peter_SSs
I
  • Question
data validation list inside google site or make it online
Replies
0
Views
165
INN
I
F
  • Question
Problem with "Worksheet_BeforeRightClick"
Replies
1
Views
129
Fibo
F
S
  • Solved
modify drop-down menu
Replies
6
Views
143
skunkworks
S
rjplante
  • Solved
numeric dropdown, with upper limit defined by another cell
Replies
5
Views
76
rjplante
rjplante

Forum statistics

Threads
1,214,819
Messages
6,121,729
Members
449,049
Latest member
MiguekHeka

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top