How to Save a Spreadsheet as a One Page PDF in Excel 2013

Turning a file into a single page PDF is a great way to make something that can be easily printed or shared.

But Microsoft Excel can be difficult to turn into something that is easily printable, and you might be struggling if you need to know how to save Excel as PDF on one page.

Luckily you can take advantage of a couple of different settings in Excel that will let you create the type of file that you are looking for.

How to Save Excel as PDF on One Page

  1. Open your Excel file.
  2. Select the File tab.
  3. Choose the Print tab.
  4. Click No Scaling.
  5. Select Fit Sheet on One Page.
  6. Choose the Save As tab.
  7. Select the Save as type dropdown and choose PDF.
  8. Click the Save button.

Our guide continues below with additional information on how to save Excel as a PDF on one page, including pictures of these steps.

Deal of the Day

Sale
Apple AirPods (2nd Generation) Wireless Ear Buds, Bluetooth Headphones with Lightning Charging Case Included, Over 24 Hours of Battery Life, Effortless Setup for iPhone
  • HIGH-QUALITY SOUND — Powered by the Apple H1 headphone chip, AirPods (2nd generation) deliver rich, vivid sound.
  • EFFORTLESS SETUP — After a simple one-tap setup, AirPods are automatically on and always connected. They sense when they’re in your ears and pause when you take them out. And sound seamlessly switches between your iPhone, Apple Watch, Mac, iPad, and Apple TV.

Last update on 2024-03-01 / Affiliate links / Images from Amazon Product Advertising API | As an Amazon Associate, I earn from qualifying purchases.

Our create table in Excel guide will show you a quick way to format some of your cells so that they are easier to filter and sort.

Saving an Excel spreadsheet as a PDF is a solution that I often use when I have data that I want to share with other people, but I want to avoid giving them the option to easily edit that data.

Unfortunately, the PDF version of an Excel worksheet suffers from the same issues that a printed worksheet does, and you may wind up with a PDF file that contains several unnecessary pages.

Therefore, you might find yourself in a situation where you need to save a spreadsheet as a one page PDF in Excel 2013.

Fortunately, you can achieve this requirement by adjusting a setting on the Print menu, then saving the file as a PDF.

Our guide below will walk you through the process so that you have a PDF file of your data that is easy to print and share with others.

You can read this article for a way that you can quickly expand all of the rows in your spreadsheet at one time.

How to Fit a Spreadsheet to One Page and Save it as a PDF in Excel 2013 (Guide with Pictures)

The steps below will show you how to adjust the settings on your spreadsheet so that the entire thing fits on one page. We will then save the spreadsheet as a PDF so that you can easily share it with others, or print it again in that format.

Do you often work with tables in Microsoft Word? This Word table to Excel article will show you an easy way to get them into a spreadsheet.

Step 1: Open your spreadsheet in Excel 2013.

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

Step 3: Click the Print option in the column at the left side of the window.

click the print option in the left column

Step 4: Click the No Scaling button under the Settings section.

how to print an entire spreadsheet on one page in excel

Step 5: Select the Fit Sheet on One Page option.

Note that large spreadsheets can print very small with this setting. You might have better results with the Fit All Columns on One Sheet or the Fit All Rows on One Sheet option.

fit sheet on one page in excel 2013

Step 6: Click the Save As option in the left column.

how to save an excel file as a pdf

Step 7: Click the Save as type dropdown menu, then select the PDF option.

change the save as type option to pdf in excel 2013

Step 8: Click the Save button to create the PDF file.

how to fit a spreadsheet to one page and save it as a pdf in excel 2013

Now that you know how to save Excel as PDF on one page you will be able to use this method whenever you need to turn a spreadsheet into a file that is easy to print or share with others.

You might find that the options you selected above don’t provide the exact results that you were looking for. In that case, check out our Excel printing guide to see some of the options and settings you can use to produce a file with your most optimized print options.

If you have a Google Sheets file that you would like to turn into a different file type, then check out our convert Google Sheet to PDF tutorial and find out how.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy