ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Maximum Characters in a cell (https://www.excelbanter.com/excel-worksheet-functions/217647-maximum-characters-cell.html)

Brosenberg7

Maximum Characters in a cell
 
I have more than the maximum characters in a cell and therefore can not see
everything unless I click on the cell itself. Is there a way to expand the
maximum characters allowed to be able to see everything in the cell?

Dave Peterson

Maximum Characters in a cell
 
Excel's help says that about 1000 characters will be visible in the cell.

But if you add alt-enters to force new lines within the cell, you can see way
more than the documented number.

Brosenberg7 wrote:

I have more than the maximum characters in a cell and therefore can not see
everything unless I click on the cell itself. Is there a way to expand the
maximum characters allowed to be able to see everything in the cell?


--

Dave Peterson


All times are GMT +1. The time now is 02:37 PM.

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