How to Save Excel as PDF Landscape (with Quick Steps)

Step 1 – Customizing Page Setup

  • Click on the Page Layout tab.

Customize Page Setup for PDF in Excel

  • In the Page Setup group, click on the down-arrow of the Margins button.
  • Select Normal.

Customize Page Setup for PDF in Excel

Normal is set as the default margin.

Now let’s change the orientation, the most important part of the process.

  • In the Page Setup group, click on the down-arrow of the Orientation button.
  • Select Landscape mode.

Customize Page Setup for PDF in Excel

Our sheet now looks like this:

The dotted line on the right side indicates where the edge of the page will be in a PDF file.

Now, let’s set the paper size.

  • Click the Size button.
  • Select A4 as the paper size from the drop-down.

Customize Page Setup for PDF in Excel

The dotted line changes according to the selected paper size. In our example, it has extended.


Step 2 – Defining the Print Area

In this step, we define the Print Area, Page breaks, and Page scaling respectively.

  • Select the range to be printed in the worksheet.
  • Select Print Area from the Page Setup group.
  • Click Set Print Area.

Define Excel Print Area in Excel to save in PDF

  • To add Page breaks, click on the Breaks button.
  • Select Insert Page Break from the list.

Define Excel Print Area in Excel to save in PDF

Page breaks will now be inserted when saving this file in PDF format.

  • To set up the Page scaling, in the Scale to Fit group, keep Width, Height, and Scale in their default modes.


Step 3 – Setting Up Sheet Options for Landscape Orientation

Let’s set up our individual sheets before saving them in PDF.

  • Click on Print Titles from the Page Setup group.

Set Up Sheet Options to save in PDF

  • The Page Setup window appears.
  • Click the Sheet tab.

Here we can modify the Print area, Titles, Order and other sheet settings.

  • Click on the Print area box.
  • Select the range on the sheet to be printed.

Set Up Sheet Options to save in PDF

  • Press OK.

The selected area is marked for printing.


Step 4 – Saving in PDF Format

The Excel file is set up for landscape format. Let’s save it as a PDF.

  • Click on the File tab of the worksheet.
  • Select Save a Copy from the list.

Save the Excel file into the PDF

  • Browse to the location of the file in the File Manager and select it.
  • Select PDF as the Save as type.
  • Click Save.

Our Excel file will be successfully saved as PDF in landscape mode.


Related Articles


<< Go Back to Page Setup in Excel | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo