How to export all sheets as separate files: sheetName.pdf from workbook?

Copper Contributor

Hello, we're using Microsoft Excel for mac version 16.84. We can create workbooks with sheets. But, we cannot see how to export all workbook sheets as separate pdfs documents, with their names as file names.


It is possible to export the whole workbook as a pdf and then drag the individual pages out as their own .pdf docuuments; but they are saved as 1(dragged).pdf 2(dragged.pdf) etc. We lose the name.
Has anybody else had this issue? Is there any way to export them with their names, as in previous versions of the software?


Thanks all.

0 Replies