Save Excel Spreadsheet Full Sheet Options

Before you click Print, look through your print preview to make sure everything looks correct.

For example, if you wish to send out only a specific portion of a larger sheet, or you dont want it to be editable.

However, converting an Excel file to a PDF can be a bit tricky.

However, when it comes to turning these files into PDF documents that can be read, printed, or distributed to others, its something that you should be conscious of.

Your file should be readable and understandable, without random stray columns on other pages or cell sizes that are too small to read.

Here, youll see several options grouped under the Page Setup section.

Take note that most Excel spreadsheets are more readable in landscape orientation than in portrait, unless you have very few columns.

Sheets that are saved in portrait tend to have columns that fall outside of the final print area, which can make your document very difficult to navigate and read.

Click the arrow on the lower-right corner of the Page Setup section, then click on the HeaderFooter tab.

You can select one of Offices generated options, or create one of your own by using the Customize feature.

You can select an image from your laptop or from the cloud, and this image will be tiled across your entire sheet.

This will create a thin grey line around the entire area that will be printed.

When you create your PDF, everything outside this area will not be included.

You can also manually input the cells by clicking the arrow on the lower-left corner and going to Sheets Print Area.

Go to the cell where you want to place a page break, click the Page Layout tab on the ribbon, and select Page Setup Page Breaks Insert Page Break.

This will create a break right above and to the left of your current cell.

To the right of Page Setup, youll see three options: Width, Height, and Scale.

For example, if you have a lot of rows but just a few columns, setting the Width to one page is ideal.

These are settings that affect the appearance of your final printed sheet.

Save Excel Spreadsheet Full Sheet Options

To access the full sheet options, click on the arrow on the lower-left corner of Sheet Options sections.

You can decide whether to optimize the file for Standard or Minimum, which will determine the final quality and filesize of the document.

Microsoft has a built-in PDF printer called Microsoft Print to PDF that you can select in the printer dropdown menu.

If you have another PDF drive, such as Adobe PDF, Foxit, or PDF Xchange, you can use one of those as well.

Save Excel Spreadsheet For Mac