SOLVED

Resize text in drop down list?

Copper Contributor

I am busy setting up a spreadsheet in which I use drop down lists to select the text to put in certain cells but when I click on the drop down list the text in the list is very small and I cannot read it. How can I increase the text size without having to change the size of the cell I want to add the text to?

5 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Thomas_Micklem 

Afraid drop-down box in data validation is not configurable.

@Thomas_Micklem 

Resize text in drop down

Go to the drop-down list.

Click the right mouse button.

The "Format cells" window appears.

Click Orientation.

Go to the text controls Check the box "Fit to cell size".

Click OK".

 

This will automatically adjust the text to the size of the cell.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

 

Thank you very much for this information!

@NikolinoDE 

or change the zoom factor with VBA

Actually it is not possible as Mr. Baklan has already written to you.

But with VBA you can workarond it.

You could also do it with a combo box as a workaround.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE 

I am working with VBA code to zoom into the drop down list, as it is too small to read. However, do not get the VBA code for this working with the VBA code for multiple entry in the drop down list. Have you had this experiance before and any hint how to solve it?

Thanks a lot

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Thomas_Micklem 

Afraid drop-down box in data validation is not configurable.

View solution in original post