Excel Save (pdf) Function

Question

I have a suggestion for the saving function in Excel.

It would be great if there is a function that allows one to save individual sheets in separate pdf files.

When working with Excel files that have multiple sheets divided into multiple print areas(pages), this function will be very useful.

Currently, the save as pdf function allows users to save the Excel file as a single pdf file, and it takes long time to separate the pdf file into different files.

However, if this function could be developed and added, it will be more convenient for the users.

Allowing the user to name the file could also be helpful. 

For example, 

Name of the file(that the users choose): Report_

Name of the sheets: Jan Feb Mar ... Dec

could be saved as individual files named

Report_Jan

Report_Feb 

Report_Mar 

...

Report_Dec.

If this function is already being worked on, I am glad and look forward to using the function. If not, I hope my suggestion becomes a consideration for a new feature.

Thanks

Answer 1

Hi Yubin,

We suggest you provide feedback directly to Excel product and engineering team using your Excel. In your Excel, go File > Feedback and let the team be aware of your suggestion.

The feedback you provide goes directly to Microsoft developers. Previous features have been introduced because of users like you who suggested them to Microsoft and this the right time for you to suggest yours as well.

Regards,

Christophe

Answer 2

Thanks. But if there are many sheets, for example, 30 sheets, won’t I have to make print selection 30 times?

For the print entire workbook, I’ve already tried it. It saves as a single pdf file.

Answer 3

Hi,

Welcome in Microsoft community.

I did the test at my end by printing Excel and save it as PDF. In Excel, I used the feature of **Print > Microsoft Print to PDF > Print Active sheets (**just to print a specific sheet) and then click Print. I found this to be a simple-click and time saving when Printing different sheets and save them to their specific locations.

If you want to print the entire workbook (Including all the sheets you created), you can choose Print Entire Workbook.

You can even print a part of selection in your table by using Print Selection.

For more information, here is your reference, see: Print a worksheet or workbook (microsoft.com)

Regards,

Christophe