tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,825
- Office Version
- 365
- 2019
- Platform
- Windows
My workbook contains two worksheets - sheet1 and sheet2.
Cell A1 on sheet1 contains Data Validation from a list. The list is the range A1 to A3 on sheet2.
Cell A1 on sheet2 contains text that is very long but wrap text is true. I have made its column width wide as well as its height taller, in order to be able to view it.
However, I cannot see the entire text on cell A1 on sheet1, even if I turn on wrap text / make the column width wider.
Is there any way I can make the Data Validation cell show long text?
Thanks
Cell A1 on sheet1 contains Data Validation from a list. The list is the range A1 to A3 on sheet2.
Cell A1 on sheet2 contains text that is very long but wrap text is true. I have made its column width wide as well as its height taller, in order to be able to view it.
However, I cannot see the entire text on cell A1 on sheet1, even if I turn on wrap text / make the column width wider.
Is there any way I can make the Data Validation cell show long text?
Thanks