Re: How can I increase the character capcity of an Excel cell?

Tech-Archive recommends: Fix windows errors by optimizing your registry



Have you tried widening that cell's column? Changing to a smaller font?

Just curious...How many characters are in that cell?

Something like
=len(a1)
should help you answer.



Mark Johnstone wrote:
>
> Do you know how you can get the entire contents of the cell to print. I have
> added the forced line breaks, but the contents still don't display in full
> because of the limitation in row height within Excel (409).
>
> I can only get the displayed characters to print.
>
> Thanks
>
> Mark
>
> "RagDyer" wrote:
>
> > You can increase the ability of the cell to *display* more characters (cell
> > can *contain* approx. 32,000) by strategically inserting forced line breaks
> > (<Alt> <Enter>) within the text.
> > --
> > HTH,
> >
> > RD
> > ==============================================
> > Please keep all correspondence within the Group, so all may benefit!
> > ==============================================
> >
> >
> > "Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:442F16AB-1C7A-45CD-9A6F-E2C8282A2CDC@xxxxxxxxxxxxxxxx
> > > The current maximum is about 1,100.
> >
> >

--

Dave Peterson
.



Relevant Pages

  • Re: Cell Border Width
    ... Excel has a 1024 limit on displayed characters in a cell. ...
    (microsoft.public.excel)
  • Re: Parsing Characters - Bug ???
    ... This has to do with an analyzer that colour codes individual characters ... reopening make no manual cell entries before running the macro. ... Dim char As String ... I have a complex macro that parses characters in the active cell and makes ...
    (microsoft.public.excel.programming)
  • Re: Wrap Text problem
    ... merged as a single cell, it in fact WILL display over the 256 characters I ... The actual limits are (from "Excel Specifications and Limits" ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Only Copy Subtotals
    ... Trim results in deleting everything except the last six characters. ... is where I need to remove the last six characters from each used cell. ... Once I have my subtotals copied to my totals sheet and clean the columns... ... i wrote a sub to copy the sub totals but it keys on my data. ...
    (microsoft.public.excel.programming)
  • Re: Joining Tables
    ... I have my hidden characters showing and I have my Tools - Options ... When I put my cursor at the end of the row and move one space, ... The border between the tables shows as twice as wide as a single cell ... example), but they are behaving as two separate tables, rather than ...
    (microsoft.public.word.docmanagement)