Skip to main content
Participating Frequently
January 14, 2011
Question

How can I make a pdf into lanscape form, as the original spredsheet is landscape?

  • January 14, 2011
  • 1 reply
  • 47221 views

I have an excel spreadsheet which is in landscape orientation.  When I converted it to pdf it came up as Portrait and some of the columns were on a second page, making it really hard to read.  How can I convert it to landscape in the pdf lease??

This topic has been closed for replies.

1 reply

January 20, 2011

It could be caused if the page breaks of the Worksheet are set otherwise. For instance, if the Page Orientation is set as Landscape and the page breaks are altered, the page size of the resultant PDF may not be as expected. Page Breaks can be modified via VIEW > PAGE BREAK PREVIEW in Excel. To reset the page breaks, go to PAGE LAYOUT > PAGE SETUP > Mark the "ADJUST TO ..." field as 100% of the normal size, keeping the orientation LANDSCAPE.

Also, while using the PDFMaker for conversion it is preferred that you keep the Adobe PDF Printer as the default. This can be checked via CONTROL PANEL > DEVICES AND PRINTERS.

Also, if columns spanning onto different pages is a concern, you could try "Fit Worksheet to a Single Page" or "Fit to Paper Width" options via Acrobat Preferences.

Could you please check if this works for you. If not, it would be nice if you could share the Workbook and be more specific about the Office version you're on. Thanks!

Inspiring
January 20, 2011

You might try playing with the printer properties and selecting the paper to be landscape there.


KateWaccsAuthor
Participating Frequently
January 20, 2011

Hi, Thanks for the suggestion, but the spreadsheet is uploading to acrobat into portrait.

The problem is not with the printing, it is with the actual creation of the pdf - I need to get it to upload and stay in landscape.

Any suggestions?

Thanks for your help!

[signature deleted by host]