Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I tried to export an Excel file into PDF, but it looks horrible. I need at least that one row form Excel to be saved into a one row in PDF.

I know that it is not so simple, because Excel does no have any page size. At least, they could make some estimations.

Can anyone recommend me how to save in MS Office an excel file into PDF, to have a normal look?

Thanks in Advance!

share|improve this question

2 Answers 2

up vote 2 down vote accepted

For printing to PDF or paper, look in the Page Layout section of the Excel 2007 ribbon. In the Page Setup section you can set:

  • Margins (narrow preset is nice when it just doesn't quite fit)
  • Paper Orientation
  • Paper size
  • Print Area (select the visible area you want to print, and choose Set Print Area. This will prevent printing a lot of extra white space

Some very useful options are not among the visible icons, you need to click the little square->arrow to access the Page Setup options. Among these tabs you will find:

  • Fit to x by x pages. This will force the output to fit, zooming out a bit if necessary. It is crucial to set your Print Area properly to benefit from this option.
  • Center on page
  • Headers/Footers (tip: adding page numbering and printing an entire workbook at once will show the total pages of all worksheets)
  • Rows to repeat at top / Columns to repeat at left. Similar to the Freeze Window Pane concept, this will repeat the select rows on top (or left) of every page if your table spans several pages. Usually used to include table headers and titles.

Whenever you start playing with the Paper size/orientation and Print Preview, you will see dotted lines that tells you what fits on the page or not. So you can adjust your things until it fits as you want it.

share|improve this answer

when you're using a PDF printer (e.g. CutePDF) you can adjust the margins or change the layout to Landscape rather than Portrait. you'll get exactly what you see in the print preview.

share|improve this answer
    
And what is the WorkSheet is larger? –  mxg Jan 6 '10 at 16:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.