All of your formatting translates over perfectly in just a few seconds. You can also preserve Excel workbook formatting with Acrobat on your desktop, laptop, or mobile device.
If you don’t have access to a PDF tool, you can download your workbook as a PDF directly from Excel.
- Open the File menu in the top left corner.
- Click Export.
- In the panel that appears, click Create PDF/XPS Document.
- Optimize the file for Standard or Minimum.
- Click Options and adjust settings, including the area to publish.
- Click OK.
- Name the file and click Publish.
This method is fairly simple, but some common formatting issues can arise. Page and sheet margins can look different in the PDF, with text pushed onto another row, for example, or the left margin appearing to be wider. The orientation might be wrong, or the PDF might display an entire sheet when you only wanted one area or one tile.
Change advanced settings in Excel.
To avoid common formatting issues, such as cut-off text or shifted margins, you can make adjustments in both the Page Layout tab or the Page Setup menu option. Once you’re happy with the formatting, go to File, then select Save As and choose the PDF option. Alternatively, you can save as a PDF from the Print Preview menu.
Another way to prevent issues is to make adjustments in the Page Layout tab. Look at the options in the Page Setup section to adjust margins, size, and orientation. Excel spreadsheets usually work better in landscape view. While you’re there, use the options in the Scale to Fit group to make adjustments to the width, height, and scale. These settings will determine how many rows and columns appear on each page.
Define the print area to ensure that the PDF displays exactly what you want it to. Click and drag to select the cells you want to include. On the Page Layout bar, click Page Setup > Print Area > Set Print Area. Another method is to click the arrow on the lower-left corner and click Sheets > Print Area. Then you can enter the cells you want printed.
Create a page break to control where it will appear in the PDF. Click the cell where you want it to appear, then click the Page Layout tab. Select Page Setup > Page Breaks > Insert Page Break.
As the inventor of the PDF file format, Adobe provides the best solutions and the highest quality tools for working with PDFs. You’ll get the highest quality conversions without losing formatting when you use Adobe tools. Try out a variety of intuitive and easy-to-use tools in Acrobat online services, and discover just how versatile the PDF file format can be. Discover what more you can do with Acrobat online services and Adobe Acrobat to edit, convert, print, and share PDFs.