Share via

how to fix formatting issues when saving excel sheet as a pdf

Anonymous
2023-11-16T21:13:38+00:00

in excel when saving a copy as a pdf it created dotted line breaks and then saves what should be a single page as 18 pages each with a small portion of the excel document. pages in the pdf are consistent with the line breaks. line breaks only appear once i hit "save a copy".

it is as if the size has been increased in excel to what would need multiple pages to print out.. however i have been usin the same origianl file for 2 years with no issues

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-16T22:09:14+00:00

    Thank you so much for the help... i did try as you recomended for quite some time. I feel stupid in admiting this but.... after hours of trying to correct the problem(in the same way you recommended) i saw that one of label machines had been set up as the defualt printer for both the pdf viewer and excel. resulting in the sizing issues. Trying to auto size to 4 inch wide media. hopefully no one else is as illiterate as i am with this stuff... but maybe it will save someone some time if i leave it up. thanks again for the reply Rich M

    4 people found this answer helpful.
    0 comments
  2. Rich~M 20,370 Reputation points Volunteer Moderator
    2023-11-16T21:59:12+00:00

    Hi Conner. I am an Excel user like you.

    It seems that there may be a couple pertinent questions. The first is why is Excel dividing it into separate pages, and the second is how to return it to normal.

    On the second question, on the Page Layout ribbon in the Page Setup section select Breaks and then Reset All Page Breaks. Hopefully that will remove the dotted lines/page breaks that you see.

    The first question seems the more difficult. I would start by checking the other page layout settings including the paper size and margins. If one of those somehow got changed that might explain why Excel is dividing up the pages the way it is.

    I have not experienced this problem or seen where anyone else has. So hopefully it is just a simple setting adjustment.

    3 people found this answer helpful.
    0 comments
  3. Rich~M 20,370 Reputation points Volunteer Moderator
    2023-11-16T22:13:27+00:00

    So glad you were able to figure out the issue. Come back with any issues any time.

    0 comments