ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a limit on how much information a cell can hold? (https://www.excelbanter.com/excel-discussion-misc-queries/25659-there-limit-how-much-information-cell-can-hold.html)

[email protected]

Is there a limit on how much information a cell can hold?
 
I am typing a very large description of a parcel of land in an Excel
spreadsheet. At a certain point, the text no longer appears in whole. I
only am able to see part of it. If I select the cell, then I see everything.
When I print, I only print part of it.

I have tried left indent, expanding the width, exapanding the height.
Anyone Anyone??

PegL

Excel only displays about 1024 characters in the cell. This can be adjusted
slightly by using Alt+Enters (line feeds), but you are limited.

" wrote:

I am typing a very large description of a parcel of land in an Excel
spreadsheet. At a certain point, the text no longer appears in whole. I
only am able to see part of it. If I select the cell, then I see everything.
When I print, I only print part of it.

I have tried left indent, expanding the width, exapanding the height.
Anyone Anyone??



All times are GMT +1. The time now is 01:35 PM.

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