Create PDF from an Excel file without white margins

After thousand of tries, i foud a way:

I set all the margins to 0 (Page Layout > Margins > 0 all) and then i printed with the native Windows PDF printer: "Microsoft Print To PDF".

I didn´t even knew windows came with a native pdf printer but that solved my problem.

Using the "Microsoft Print To PDF" printer resolves the issue for printed document. However, I wanted to "Save (my document) to PDF" so the text is embedded and could be copied.

Also, the "Print to PDF" command cannot be automated using a Macro (or at least I couldn't figure out how), while the "Save to PDF" command is widely documented and allows to predetermine the path and filename using a cell value.

Like mentioned in the previous comments, all page margins should be set to 0. Also, in the Page Setup > Header/Footer, both "Scale with document" and "Align with page margins" boxes should be checked.

At this point, if you Save to PDF your document, the white bleed lines should still occur in your newly created PDF document.

All you need to do at this point is to print your document using "Microsoft Print To PDF", complete the whole process and your printed/saved document should be OK.

Now, go back using the "Save to PDF" command (either in the menu ribbon or using VBA Macro) and your saved document should be ok.

I'm using Microsoft Office 2013 on Windows 10.

I encountered the same issue and fixed it by going to:

File > Options > Advanced > General (section) > and unticking Scale content for A4.

Should be find as long as you have your page sizes formatted correctly.