![]() |
Cell width problems 911!
I have a spreadsheet with a drop-down list box. I'm having issues that seem
to be compounded as indicated below... €˘ The cell width for each column is very limited and the width of the items in the cell work only with the font size of 8 or less. €˘ The drop-down list has 14 items. This causes a scroll bar in the drop-down and further impacts the issue above so that not all content can be viewed€¦ Any ideas?? |
Cell width problems 911!
Drop down rows is a property you can change. Right click the control and
pick Properties and modify ListRows if this control is from the Control Toolbox toolbar. If it's from the Forms toolbar right click it, pick Format Control, and change Drop down lines on the Control tab. I don't know what you want for the first conundrum. If you can't use a small enough font and can't widen columns I guess you have to shorten the text. -- Jim "Roberta" wrote in message ... |I have a spreadsheet with a drop-down list box. I'm having issues that seem | to be compounded as indicated below... | . The cell width for each column is very limited and the width of the items | in the cell work only with the font size of 8 or less. | . The drop-down list has 14 items. This causes a scroll bar in the drop-down | and further impacts the issue above so that not all content can be viewed. | | Any ideas?? | |
All times are GMT +1. The time now is 06:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com