Share via

Saving excel workbook as separate tabs in PDF

Anonymous
2019-01-07T15:57:05+00:00

I recently upgraded to excel for mac version 16.20 from version 14.5.  I have many workbooks that have unique tabs that I would save as separate PDFs.  I would go to file - save as pdf - workbook and it would produce separate PDFs saved as the tab name.  With the recent upgrade, I no longer can save the PDFs separately with one click of a button.  Surely there is way a to do this...right??

Thanks,

Phil

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
Answer accepted by question author
  1. Bob Jones AKA CyberTaz MVP 434.8K Reputation points
    2019-01-07T19:04:40+00:00

    Make sure you have only 1 sheet selected, then in the Print dialog confirm that Active Sheets is indicated. Just to clarify, each sheet has to be done individually... There is no built-in provision for outputting multiple sheets as separate PDFs in a single pass. That would require a VBA or Apple Script procedure to automate the process.

    If you search the Community there are several conversations which provide automated solutions, such as Saving Excel Worksheets as separate PDF Files

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-01-07T21:06:29+00:00

    Thanks for your reply, Bob.  Sounds like I will have to play around with VBA.  It's unfortunate because my old version does it--without ANY scripts/manipulation.

    Phil

    1 person found this answer helpful.
    0 comments
  2. Bob Jones AKA CyberTaz MVP 434.8K Reputation points
    2019-01-07T17:40:35+00:00

    Not using the File> Save As - PDF method. That outputs the entire file only.

    Use File> Print - PDF - Save as PDF in order to output individual sheets just as though printing to paper.

    Alternatively, right-click a sheet tab then use Move or Copy to output the sheet to a (new book) as a separate Excel file then save/output that file as a PDF.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2019-01-07T18:34:52+00:00

    Hi Bob - 

    Thank you for the response.  Unfortunately when I do the save as PDF (under print), it still simply saves it as one group PDF.  Am I missing something?  

    I know I can use the second option you provided, however, I have probably 25 of these files that all contain 20-30 unique tabs.  On the old version it was so easy to save as the tab name.  Any other ideas?  If there is no easy way I unfortunately will have to revert back to the old version.  Very frustrating.

    Thank you, Bob.

    Phil

    0 comments