To convert all worksheets and save as a PDF file from all worksheets without any formatting, follow these three steps. 1. In Excel, select multiple worksheets from a cell A1 to A9; or Select a single worksheet from cells B1 to B3: 2. To open the ribbon interface, click on the File tab, scroll down to ‹Save a file as›, and choose a save format. (e.g. Open with…) 3. Click Add Formats. 3. Select the following formats — Image/AES, PDF (for non-RTF), and XPS (only when you are saving an entire workbook — e.g. a spreadsheet) 4. Click Add Formats again and select the following formats — Microsoft Office Excel V.2002, Microsoft Office Excel V.2003, Microsoft Office Excel V.2004, Microsoft Office Excel V.2005, Microsoft Office Excel V.2006, Microsoft Office Excel V.2007, Microsoft Office Excel V.2008, Microsoft Office Excel V.2009, Microsoft Office Excel V.2010, Microsoft Office Excel V.2011, Microsoft Office Excel V.2012 5. Click Save. 6. Press Enter to start converting the worksheets. After the operation completes, you will see the new PDF file. How to Save Excel As PDF in Office 2023 — PDF Viewer 1. Click on the little symbol of the PDF Viewer. 2. In the PDF Viewer, from the drop-down menu, choose Export format and click the ‹Create ‹Save› button. 3. Select a save format. 4. Click on the ‹Open› button in the toolbar to start viewing the workbook in PDF Viewer. Click on the PDF document. Then the Previewer will open, and you can read/write the file. Excel File Formats in Office 2007 Microsoft Office Excel 2023 allows you to create various types of documents for different file formats. Office Excel 2007: 1. You can save files from a wide variety of format. Exchange To open or create a mailbox file in Office 2007, press F11 or choose File > Open Mailbox. In Microsoft Office 2007, you can easily copy items from a mail, a message or a folder directly to an Excel document (even if the mailbox is spread across multiple files). 2.