+ Reply to Thread
Results 1 to 6 of 6

Convertin excel sheets to PDFs, pages have half a page of blank space

  1. #1
    Registered User
    Join Date
    12-28-2018
    Location
    Pennsylvania, US
    MS-Off Ver
    Excel 2016-Windows 10
    Posts
    13

    Convertin excel sheets to PDFs, pages have half a page of blank space

    I have a workbook with about 16 tabs. I want to convert this workbook into a PDF with one tab per page. In order to properly view the sheets, I have in page layout set the scale-to-fit height to 1 page.

    The problem is when I go to the view tab and view the page layout, a lot of the tabs only take up half of the width of the page, leaving about 6 blank columns to the right of the last column on the page. I haven't changed the width scale to fit at all but for some reason when I set the height scale to fit to 1 page, it condenses the width of the sheet and leaves about 6 columns of blank excel sheet on the page for seemingly no reason. I have deleted these blank columns and still nothing.

    How can I fix this so when I convert these sheets to PDF, they take up the full page and are easy to read?

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    641

    Re: Convertin excel sheets to PDFs, pages have half a page of blank space

    have you tried in Page break view for that sheet?
    pls refer the link for more info:
    https://support.office.com/en-us/art...f-ed640612bdc2
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Registered User
    Join Date
    12-28-2018
    Location
    Pennsylvania, US
    MS-Off Ver
    Excel 2016-Windows 10
    Posts
    13

    Re: Convertin excel sheets to PDFs, pages have half a page of blank space

    This does not seem to solve the problem. Even after I insert a page break, when I checked the page layout and the print preview it still had the sheet only taking up half the page.

    I've attached a picture of the first few lines of the sheet in page layout view to show the issue.
    Attached Images Attached Images

  4. #4
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    641

    Re: Convertin excel sheets to PDFs, pages have half a page of blank space

    you have to see in page break view, where you can see some blue dotted lines, pls refer the link in post#3

  5. #5
    Registered User
    Join Date
    12-28-2018
    Location
    Pennsylvania, US
    MS-Off Ver
    Excel 2016-Windows 10
    Posts
    13

    Re: Convertin excel sheets to PDFs, pages have half a page of blank space

    I saw. However after inserting the page break it still saves the sheet in pdf on only half of the page. This is the newly saved pdf with the page break. It is still only half the page
    Attached Images Attached Images

  6. #6
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    641

    Re: Convertin excel sheets to PDFs, pages have half a page of blank space

    you saw the blue lines & you can adjust that blue line as you required to print it. Did you try to adjust the blue lines?

+ 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