Forum Discussion
Thomas_Micklem
Jun 13, 2021Copper Contributor
Resize text in drop down list?
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 rea...
- Jun 13, 2021
Afraid drop-down box in data validation is not configurable.
NikolinoDE
Jun 13, 2021Platinum Contributor
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.