Skip to main content
C
christinah79607898
Participant
June 8, 2017
Question

excel to pdf - one page turns into multiple pages

  • June 8, 2017
  • 9 replies
  • 104467 views

Hi Adobe

I have one page en excel, but when I save it as pdf, it splits up into 9 pages where the font now is very large and words are on top of each other.

What can the problem be?

Best regards

Christina

    This topic has been closed for replies.

    9 replies

    B
    Bryan34402451vefo
    Participant
    December 21, 2023

    None of the solutions listed here worked for me. I did find an alternative solution if you're in the same boat. Check your default printer and make sure it isn't set to something like XPS Card Printer. Setting it to Adobe PDF Printer solved it for me, though I think setting it to any standard printer should work.

      Jono_San
      Jono_San
      Participant
      September 8, 2022

      For me, setting print area and then printing to PDF did the trick. Never had this issue on Widnows... but Excel for Mac or Adobe conversion on Mac is not as intuitive.

      D
      defaulte3i7b3habhyd
      Participant
      June 1, 2021

      I realized that Microsoft set my labelmaker as the default printer over the weekend, and when I save as a .pdf, it is saving it as the labelmaker print format.  Check that out if you are suddenly having an issue!

        J
        JWACG
        Participant
        July 15, 2020

        Assuming you have the pagination correct, the most direct way to print would be :

        1. Open excel sheet

        2. (next to Apple logo) -> File -> Print -> PDF (bottom left corner)

        K
        karenzea
        Participant
        February 24, 2020

        Thanks for your suggestion.  It worked perfectly on all sheets apart from those with multiple pages.  Those (excel) pages have all been squeezed onto one (PDF) page, like a long line of my excel pages down the centre on one PDF page.  Any idead?

        J
        JWACG
        Participant
        July 15, 2020

        If you're using Windows, in EXCEL go to VIEW -> Page Break Preview.
        What you're viewing is the full screen for working on the screen hence all the page breaks are not shown.

        D
        DustyPaws
        Participant
        September 25, 2019

        Resurrecting an old thread because this was driving me mad and the search led me here.

         

        In Excel go to Page Setup, in the Page tab select Fit to: 1 by 1

         

        Job done!

         

        Hopefully this will help other lost souls like me 🙂

          J
          johnvhoward
          Participating Frequently
          October 4, 2019
          Thanks! This was the last thing I tried, including changing page orientation and page (paper) size in Excel, and it worked like a charm. Problem solved!
            K
            kbenderil
            Participant
            May 9, 2019

            I'm having the same issue and tried the trouble shoot you suggest. However when I go into settings in Adobe Acrobat and click on Microsoft Excel files, in the window on the right it says, "There are no settings that can be edited in Microsoft Excel Files."  And the "Edit" box is deactivated.  I'm signed in and everything. I'm very frustrated!

            Luke Jennings
            Luke Jennings
            Inspiring
            May 13, 2019

            From Excel, go to File> Save as> PDF> Workbook. If this is cropping the Excel sheet into multiple PDF pages, select all cells on the first sheet and go to File> Print area> Set print area, this should give you a PDF of the entire sheet. (I use a Mac).

              K
              kbenderil
              Participant
              May 13, 2019

              Hi Luke,
              I had already done that.  I had set the print area so that it was only one page. I had dragged all my page breaks out to capture everything into a one-page document.  I was clearly stretching the limits of the page breaks to get it on one page but I did it. It seems manually setting page breaks and  "Set Print Area" is still going to be over-ridden with Adobe PDF wanting to capture it differently.  As soon as I "Save as PDF", all the page breaks are back.

              I tried everything I could think of. The only way I was able to get it all on one page was to change my background color to white in Excel so grid lines wouldn't show up, and then do selected screen captures, and then paste them into a Word document.   That's clearly not a solution, it was merely an end-around. This is clearly a glitch with Adobe.  Adobe needs to make manual page breaks and set print area as a priority when converting to PDF.

              virginiad1264306
              virginiad1264306
              Participant
              June 8, 2017

              I am having the same issue.  I am opening up an excisting pdf file using Acrobat Pro DC  and adding an excel file by dragging file into the pdf thumbnail section.  It totally changes layout of the excel file from landscape to portrait.  If I do this using my older computer that has an older version of excel it does not change the layout, but if I use my new computer that has a the newest version of excel it changes the layout....so thinking int might be an excel/microsoft issue?  Maybe a setting in excel? Both computers have the same version of  Acrobat Pro DC.  Really need to get this figured out as I use this function a lot for work!!!

              Thank you,

              Virginia

              Adorobat
              Community Manager
              AdorobatCommunity Manager
              Community Manager
              June 8, 2017

              Hi Christina,

              As per the description, you are converting a single excel page into a pdf but it results into 9 pdf pages as well as the fonts are bigger in the resultant pdf, is that correct?

              If using Acrobat to convert Excel to PDF, try changing the following setting and see if that works:

              1- Launch Acrobat>click Edit>Preferences>Convert to PDF

              2- Click Microsoft Office Excel>click Edit Settings

              3- Check the box next to "Convert entire Excel workbook"

              4- Click OK and try again.

              Also, try converting another excel file into pdf and see if this behavior continues.

              Are you converting excel into pdf using Adobe Acrobat's Create PDF option or using File>"Save As" or "Save as Adobe PDF" option in Excel?

              Awaiting your response.

              Shivam

              L
              Lyle5EA3
              Participant
              November 26, 2020

              This is dated information and didn't work.

              Excel now has a specific convert to Adobe option, however the issue still persists three years later.

                Terms & ConditionsAccessibility statement
                Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices