none
Column width calculation in Excel to PDF RRS feed

  • Question

  • I am trying to convert a Excel document to PDF. The Excel document has 64 pixels width for first 10 columns. The document uses the font as Arial and size 10. I am using the A4 Sheet size for PDF in which the first 10 columns should fit. But, Excel only fits 9 columns. In this document right and left margin set to 0.7 inches. 

    Expected : 

    Portrait Orientation

    System Resolution : 1360 x 768

    Available Sheet Size after subtracting margin  = (8.27 - 1.4) x 96 = 659.52 pixels

    First 10 columns with 64 pixels width = 64 x 10 = 640 pixels 

    640 pixels can be fit into 659.52 pixels PDF page.

    Result

    Only columns from 1 to 9 is fit into the first page of PDF.

    What is logic or behavior of Excel for converting the document to PDF. What kind of scaling it uses?



    • Edited by MOHANc95 Wednesday, January 8, 2020 8:50 AM Added additional details of this query
    Wednesday, January 8, 2020 8:48 AM

All replies

  • When sending Excel to a PDF file Excel uses the Print Setup to determine how to position on the paper.

    Therefore open Page Setup

    Select the paper size.

    Set scaling to fit 1 page wide.

    If it is only a single page then also set 1 page tall. However, if multiple pages then leave the tall field blank and it will uses as many pages as required but fit to one page wide.


    Regards, OssieMac

    Wednesday, January 8, 2020 10:56 AM