+ Reply to Thread
Results 1 to 2 of 2

printing limitation

  1. #1
    Registered User
    Join Date
    10-06-2005
    Posts
    1

    printing limitation

    Hi

    i am printing a spreadsheet in excel 2003 and one cell in it has more than 1024 characters ,in printout cell gets truncated after 1024 characters ,is it a limitation of excel or is there any workaround for this issue.

    Thanks
    bo

  2. #2
    Gord Dibben
    Guest

    Re: printing limitation

    bo

    Excel Help on "limits" or "specifications" reveals that Excel will allow
    32,767 characters to be entered in a cell.

    However, it goes on to state that "only 1024 characters will be visible or can
    be printed"

    To work around this limitation, stick a few ALT + ENTERs in at appropriate
    spots, about every 100 characters..

    The ALT + ENTER forces a line-feed and expands the 1024 limit.

    How far is not really known. Just experiment.

    .........From Dave Peterson..........

    I put this formula in A1:
    ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy"

    And adjusted the columnwidth, rowheight and font size and I got about 7300
    characters to print ok.

    .........End Dave P.................

    Failing that, use a Text Box to store the text or MS Word which is a word
    processing application, unlike Excel which is not.


    Gord Dibben Excel MVP


    On Thu, 6 Oct 2005 11:21:14 -0500, ar8824
    <ar8824.1whpud_1128618310.8504@excelforum-nospam.com> wrote:

    >
    >Hi
    >
    >i am printing a spreadsheet in excel 2003 and one cell in it has more
    >than 1024 characters ,in printout cell gets truncated after 1024
    >characters ,is it a limitation of excel or is there any workaround for
    >this issue.
    >
    >Thanks
    >bo



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1