How To Save Excel File As Pdf In Windows 10

If you lot desire to salve your Excel spreadsheet as a PDF, here'southward what you'll need to do.

While certain files can hands exist converted to other formats, that isn't truthful for Excel files. While you can embed Excel data elsewhere, it isn't a format that converts well to other document formats like PDFs.

This is largely due to formatting. Excel files, with its cell grid structure, accept to be set up in a way that allows the data to be presented without losing its layout. To save an Excel spreadsheet as a PDF, hither'due south what you demand to do.

Setting Page Layout and Pattern in Excel

While page layouts and margins aren't commonly visible in Excel, they exercise be. Every bit a PDF is a certificate format that displays content across pages, it'due south of import to ensure that your Excel data can easily be displayed without the layout being broken.

That's why changing the page layout in Excel is the first thing yous'll need to do before you can relieve it as a PDF file. To start, open up your Excel spreadsheet and press thePage Layout tab on the ribbon bar.

From here, you can decide the folio margins, orientation, size, and overall print area. All four elements can impact how your Excel file is displayed when converted to a PDF.

While the default page margins should be acceptable, press the Margins button and select i of the available options in the drop-downwards menu if you want to change them. You may do this if you lot want less (or more) white infinite effectually the edges of your data.

Past default, Excel is fix to aPortrait page orientation. If you have a big number of columns, you lot may wish to switch this toLandscape instead.

You can practise that past pressing the Orientation button and selecting one of the options available.

The page size will have the biggest touch on how much Excel data yous can fit onto a single page. These are based on typical physical paper sizes.

Press theSize button and select ane of the page sizes from the driblet-d0wn menu. A4 is recommended in almost cases as a common size to allow for printing.

Setting Excel File Print Options

When you select a impress area in Excel, you determine the cells you wish to print. Setting this as well allows you to select the data you wish to save to your PDF file if you cull to impress to a PDF file directly.

Select the columns and rows you wish to see in your PDF file using your mouse. With the information selected, clickPage Layout > Print Area > Set Impress Area.

If you have a vast amount of data in your print area (for instance, with a large number of rows or columns), you tin can change how many of them appear on a unmarried page.

Select a number of rows or columns within your print expanse, and then set theWidthorHeight options under the Page Layout > Scale to Fit department to1 page. You lot can also change the overall calibration percentage (the corporeality of space the impress area will utilise to make full a folio) using the Calibration option box provided.

You lot can besides make further changes to your final Excel layout by pressing thePrint Tilespush.

In theFolio Setup window, alter any of the bachelor options listed under thePrint andPrint Titles sections. Whatever change you brand will be added to your final, converted Excel to PDF document.

Converting an Excel File to a PDF

There are two ways y'all tin convert an Excel file to a PDF.

The outset is to save information technology equally a PDF file directly—to practice this, printingFile > Save Equally and ensure that PDF is selected under theRelieve as type drop-down menu. PressSave one time you're fix.

Windows users tin also impress to a PDF file, saving the printer output to a file rather than printing it. This will utilize many of the print options above to your file and will apply the print area you set. This is a expert option if yous simply want to save some of your Excel information to a PDF file.

To do this, printing File > Print and selectMicrosoft Print to PDF from the printer list. PressImpress in one case you lot're gear up.

In theSave Print Output As window that appears, select where to relieve your file, requite the file a proper name, then press Save to save the file.

Using Excel Information Elsewhere

Saving an Excel spreadsheet as a PDF is ane way to use your Excel information in some other format. Information technology'due south easy to insert Excel data into PowerPoint, as well as consign it to other Part software similar Word.

You might also be able to copy and paste Excel data into other files and software without losing its formatting, too, although your mileage may vary.