Share this content
0
952

Excel Printing to PDF - Tabs as Individual PDF's

Excel Printing to PDF - Tabs as Individual PDF's

Happy Friday everyone. 

I have several large spreadsheets, each containing lots and lots of tabs. 

Each tab, unbeknown to me, don't have the same print layout. I can fix this, but I then need to save each individual tab to an individual PDF. 

Is there a way to do this quickly? The PDF would ideally save as the name of the tab. 

Thanks in advance.

Replies

Please login or register to join the discussion.

avatar
10th Aug 2018 10:16

Not I know of with out resorting to a code.

Thanks (1)
avatar
10th Aug 2018 10:46

using VBA code you can loop through each sheet and then print it out to a pdf, picking up the tab name for each sheet. There are a number of tutorials for this, one example is https://powerspreadsheets.com/save-excel-file-pdf-vba/

Thanks (1)
By mrme89
to elliottrob
10th Aug 2018 11:15

Thanks.

I've tried something like this, but seems to stop after so many sheets.

Looks like I'll have to try harder down this avenue.

Thanks (0)
avatar
to mrme89
10th Aug 2018 13:25
Thanks (1)
avatar
By daniel_
10th Aug 2018 11:08

There's a nifty free program called PDFill PDF Tools.
I use it to split apart PDF into multiple files, combine PDF files, trim out pages, rotate pages.

It's not the most elegant way of doing it, but it works in a pinch.

https://www.pdfill.com/pdf_tools_free.html

Thanks (1)
By mrme89
to daniel_
10th Aug 2018 11:16

Thanks.

Unfortunately in a massive organisation. I've no chance of getting that programme ha.

Thanks (0)
Share this content