To export a workbook as a PDF file: Click the File tab to gain access to Backstage view. Click Export, then select Create PDF/XPS. Exporting a PDF file. The Save As dialog box will be. Select the location in which you want to export the workbook, enter data name, then click Publish. Exporting a PDF file.