Share via

Expand drop down box width

Anonymous
2015-06-02T13:58:36+00:00

I am using Excel on my Samsung Galaxy Tab7 and on my iPad Air. I have the exact same issue on both when viewing a drop down box. It will show 13 characters followed by ...

ABCDEFGHIJKLM...

Considering my drop down list has multiple objects that start off the same I need to see the end of the string. Is there a way to expand the width of the drop down?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-06-03T01:19:51+00:00

    Hello,

    I see you are using Excel for Android. The limitation you show in the screenshot does not show in Desktop Excel 2013, even when using merged cells (which should be avoided).

    I believe that the issue lies with the Android / mobile version of Excel. Excel for mobile does not have the full functionality of desktop Excel, and it seems that this is one case where it falls behind: rendering a drop-down across all merged columns. 

    My suggestion is to re-arrange your spreadsheet. Unmerge the cells and widen the column with the drop-downs. Align all the entry cells below row 30 to use the same column instead of scattering the cells around different columns.  If the goal is to make the spreadsheet work on Excel for Android, you may need to make some concessions to that platform and adjust the spreadsheet accordingly.

    Thank you for the insight Teylyn, Unfortunately my customer will not allow us to modify their spreadsheet like that. It looks like we will have to go back to lugging around laptops for now.

    0 comments