The following screenshot illustrates this: Now, after saving if we wish to view the converted PDF file, then checkmark the option: ‘Open file after publishing’ in the ‘Save As’ dialog box. Click on ‘File’ and then click on ‘Save As’ as below:.If the entire Excel file needs to be saved as a PDF file, this step will be ignored. If non-adjacent worksheets are to be converted, press the ‘Ctrl’ button while clicking the tabs of each worksheet that need to be saved as PDF. If several adjacent worksheets are to be converted, then click the tab for the first worksheet, press the ‘Shift’ button, and then click the tab for the last worksheet. If a certain worksheet is to be exported, then it has to be made active by clicking on the sheet’s tab. If a table is to be exported, then place the cursor on any cell within the table. Open the Excel file and select the range of sheets that need to be converted to PDF format :.Now, if we wish to export any selected range, table, or worksheet, or the entire file to PDF format, then we follow the below steps: Let us say we have an Excel file that has 4 worksheets in it. In the below examples, we will show how an Excel file can be converted to PDF format: Some common ways to convert an Excel file to PDF format are: 1. Excel functions, formula, charts, formatting creating excel dashboard & others Examples to Convert Excel File into PDF Format
