Formatting issues when converting excel file to PDF

Anonymous
2017-09-21T17:36:41+00:00

Issue: I have a multi-tab excel document whos content varies on each page, such that row and column spacing isn't the exact same on each. When I PDF it, the sizing gets weird- some pages are filled while others have big spaces, some have very thin margins while others have thick ones, for some the page border is centered while others are off-center, and the borders themselves will get cut off.

For each tab, I have tried: 1) scaling  to fit 1 page, 2) setting up the borders the same, and 3) manually adding and deleting columns/rows. I've also tried searching online for a solution but this seems to specific.

It seems to be a little better when I PDF 1 page at a time then combine them in Adobe, does that perhaps indicate its an Adobe problem?

Any help is greatly appreciated.

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 No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Anonymous
    2017-09-21T18:28:06+00:00

    Is your Adobe version up to date? I use a free pdf converter and frequently print such excel multi tab docs without any issues. Do you have the same problem using the MS built in print to pdf?

    0 comments No comments
  2. Anonymous
    2017-10-19T23:48:24+00:00

    Thank you for the info! I'm not sure about the pdf converter - do you have a program name you can share? And yes the built-in print to PDF s equally problematic.

    0 comments No comments