How to Create Multiple PDF files in Microsoft Excel without going to File>Export and then selecting the Save option. If you want to create multiple PDF files in Microsoft Excel you can use this tip. Open a new Excel sheet (i.e. not in a new workbook, but inside an already open workbook). 1. Choose File>New Sheet 2. Choose the desired options and click on Continue How to Convert Multiple Excel files or sheets to PDF in Microsoft Excel without going to Workbook>Export and then selecting the Save option. When you click on the save option, you cannot select the save a different folder or files. If you select a different file, Excel will overwrite it. If you select a folder, you will get an error Tips: This tip works fine if you are using Excel 2007,2008 and later. If you are using Excel 2007, you might need to enable the “Open Existing Workbooks from the Internet” option: 3. Click on File > Open 4. Select the workbook you want to convert to PDF The PDF file will be created in the temp-folder. How to Convert Excel Worksheets to PDF without using Save function. You can use this trick in Excel 2022 and earlier versions, and also in Excel 2013.