ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text not display in a cell. (https://www.excelbanter.com/excel-discussion-misc-queries/246220-text-not-display-cell.html)

mmckenzi23

Text not display in a cell.
 
I have entered text in a bulleted list (approximately 20). When I look at
that cell from a total spreadsheet perspective only one-half of the bulleted
list is displayed. When I look at the cell individually all the the bulleted
list is shown.
Any suggestions?


Dave Peterson

Text not display in a cell.
 
Maybe the text is too long.

Excel's help says that you can see about 1024 characters in the cell. But if
you add alt-enters (to force new lines within the cell) every 80-100 characters,
you can see lots more.


mmckenzi23 wrote:

I have entered text in a bulleted list (approximately 20). When I look at
that cell from a total spreadsheet perspective only one-half of the bulleted
list is displayed. When I look at the cell individually all the the bulleted
list is shown.
Any suggestions?


--

Dave Peterson


All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com