There is also a Power Automate option for converting Excel to PDF which means you can create automated processes that convert your files to PDF using WPS Office. Luckily it’s pretty easy with WPS Office. It's not really possible to edit the PDF now, so if you need to make changes you'll want to make them in the Excel document and then create a new PDF.Ĭonverting your Excel files to PDF is a common task. If it doesn't open by automatically, just double-click the name of the file in the folder to which you saved it. Review the PDF. By default, the PDF file will open automatically for your review. Name the file and click Publish. This exports the selected information to a new PDF file with the name you've entered. When using Excel if the page break size is altered to modify the print area, on exporting the Spreadsheet to PDF, the resulting page size may differ. If you want to change the location to which you're saving the file, you can navigate to that folder in the window now. the person using the exported report, the best format to use is PDF because. "Minimum size" will reduce the size of a larger file to something more manageable. For example, some Word and Excel export format options are better suited for. Most people can stick with "Standard" unless the spreadsheet is very large. If you want to choose specific pages from the workbook to save as a PDF, use the "Page(s)" drop-down menus to define the first and last pages.Ĭhoose your optimization (optional). Above the "Options" button, you can select how you want to optimize the PDF.If you'd rather save the entire visible worksheet as a PDF, choose Active sheet(s) instead.If you selected an area of your spreadsheet to save as a PDF, choose Selection under "Publish what." This ensures that only that selected area is saved as a PDF.Note that PDF conversions cannot be easily reverted back into an Excel sheet, but this method will preserve your original copy.Ĭlick the File menu. It's at the top-left corner.Ĭlick Export on the menu. This opens the Export panel.Ĭlick Create PDF/XPS. Look for the icon that looks like a sheet of paper wearing a belt.Ĭlick the Options… button. This will allow you to adjust the settings for the PDF file you are about to create. Choose spreadsheet as your export format, and then select Microsoft Excel Workbook. Select the part of the Excel spreadsheet you want to convert to PDF (optional). If there's only a certain part of the Excel file that you want to turn into PDF format, select it now. Choose Excel file How to Convert Excel to PDF Free Choose the XLS or XLSX file you want to convert from your computer. Click on the Export PDF tool in the right pane. If you don't have Excel, you can use Google Sheets, a tool on Google Drive, to make the conversion for free. If you have Microsoft Excel, you can easily convert your spreadsheet to a PDF by saving or exporting it within the app. Create and assign variables Dim As String Dim Dim rng As Set ws Sheets(Sheet1) Set Save a range as PDF rng.ExportAsFixedFormat Type. PDFs are also easier to print and distribute than Excel spreadsheets. Converting an Excel file to a PDF makes it easier for people to open the and view the file on various platforms-even if they don't have Microsoft Office.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |