Home » Questions » Computers [ Ask a new question ]

Excel 2007 Save as PDF with pagesize/pagewidth auto or not breaking Excel lines

Excel 2007 Save as PDF with pagesize/pagewidth auto or not breaking Excel lines

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.

Asked by: Guest | Views: 234
Total answers/comments: 2
Guest [Entry]

"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."
Dzanex [Entry]

lipitor 40mg canada <a href="https://lipiws.top/">order atorvastatin 10mg for sale</a> lipitor price