+ Reply to Thread
Results 1 to 7 of 7

Save As PDF Cuts off text in cells

  1. #1
    Registered User
    Join Date
    09-12-2016
    Location
    England, UK
    MS-Off Ver
    2007 - 2016
    Posts
    54

    Save As PDF Cuts off text in cells

    Good morning all,

    I have a problem saving a spreadsheet to PDF format with Excel 2013.

    I have created a landscape table of data with varying row heights due to the amount of text in each cell, and all cells are set to wrap. Whilst viewing this in Excel itself everything appears as it should. (Please see attached PDF in question)

    The problem occurs when I go to print the spreadsheet or save it as a PDF. The cells seem to shrink, or the text expands, and cuts off many of the last lines of text in the cell, please see on page 3 of the PDF where text appears to cut off.

    I have been trying to get this to work for over an hour now, can anyone shed any light on this issue?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Excel 2013 Deluxe
    Posts
    615

    Re: Save As PDF Cuts off text in cells

    You might try to center the values vertically in each row, and auto fit row height before printing. Also I've had better luck with printing to pdf rather than saving as pdf.
    HTH
    Pete

  3. #3
    Registered User
    Join Date
    09-12-2016
    Location
    England, UK
    MS-Off Ver
    2007 - 2016
    Posts
    54

    Re: Save As PDF Cuts off text in cells

    Thank you Pete. In the end I Alt+Enter a blank line after the final line of text in the cell. This seemed to have cleaned it up rather nicely, but next time I will try print to PDF instead. Thank you for your suggestion.

  4. #4
    Registered User
    Join Date
    01-19-2019
    Location
    Toronto, Canada
    MS-Off Ver
    16.21
    Posts
    1

    Re: Save As PDF Cuts off text in cells

    I was having the same problem until I selected 'sheet' instead of 'workbook' when I saved as a pdf.

  5. #5
    Registered User
    Join Date
    02-26-2019
    Location
    not here
    MS-Off Ver
    office 365
    Posts
    1

    Re: Save As PDF Cuts off text in cells

    This problem is not solved for me. Excel still truncates the text field when saved to PDF, and the PDF page itself has a lot of space left at the bottom! Solutions above do not work, and nobody in my IT support has a clue.

    I can export the excel file as .htm and the text fields are not cut off... I'm at a loss to resolve
    Last edited by BandyRFC; 02-26-2019 at 04:07 PM.

  6. #6
    Registered User
    Join Date
    03-07-2019
    Location
    Cleveland, Ohio
    MS-Off Ver
    10
    Posts
    1

    Re: Save As PDF Cuts off text in cells

    If your issue isn't yet resolved then try going to Page Layout>Print Area>Add print area (now at this stage include 3 more rows in the print area at the bottom) and then>Set print area.
    Now go to File>Print>Microsoft print to PDF and see whether the complete content is getting included in the print area. If yes, go ahead and save it. If not, go back and try increasing the print area. It just worked for me.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    47,812

    Re: Save As PDF Cuts off text in cells

    INV, thanks for the input
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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