Excel Formatting for "Save As PDF"

[Haunz10]

I'm having issues in border formatting to produce a clean looking document after saving as a PDF. I need to use "Save as PDF" due to there being multiple tabs in my work book. This is an excel file that is updated weekly to present at my workplace in order to give updates on how we are tracking with our plans. The actual excel file itself now has normal, extra thick, bold, double line, and dotted borders. Each time I address one cell a different issue arises and some cells I just cant seem to be able to fix. I have spent way too much time on this already and am hoping someone can help me out here.

 

[ekrause]

Try using the "Page Break Preview" in the View tab of the ribbon. This should show you what will be printed/Saved as PDF. You can tinker around with the sizing of each sheet by clicking and dragging the Blue Lines (both solid and dashed) and you can choose to exclude information from being printed. Anything in Dark Grey will be ignored when printing/saving to PDF.

Is that what you were looking for or was it more regarding the formatting of cells when saving to PDF?

 

[Haunz10]

Hi,

Thank for responding. That's something different than what I am dealing with. I simply want the formatting to come out the same in PDF as I see it in Excel. I used bold outline to make important number stand out and bold borders wont always show up on the PDF, or they will show up around different cells that where I had put them.

 

[ekrause]

I'm afraid I won't be able to help with that problem. At least with out seeing the source excel and how it is being formatted in PDF. Sorry. Best of Luck