a better way to export spreadsheets as PDFs?

[wfriedwald]

Whenever I try to export a spreadsheet as a PDF, it always comes out wrong ... my spreadsheets have about six-seven columns, and somehow it puts everything after the first three columns on seperate pages, making them impossible to read, and pretty much useless. (I can share some files as examples of what I mean.)

Is there a better way to do it?

Thanks!

 

[FreakinEurekan]

Just a matter of formatting. You can Scale the output - assuming you're using Numbers, press Command-P and slide the "Scale" slider back & forth until it looks right. Then export.

 

[mfram]

If you select the Print option you will get a preview of what will be exported. Then you can adjust scaling settings. Instead of printing to a printer you can save as PDF. This is how it works on Numbers anyway.

 

[gilby101]

Try: 1) Landscape, 2) Smaller font, 3) Narrower columns with text wrapping.

 

[bradman83]

Is this in Excel? (The PDF properties would imply yes).

If so go to the View tab in the Ribbon and select Page Break Preview. This will show you how Excel plans to print the spreadsheet. You can then manipulate the blue page break outlines by dragging them to expand or shrink the areas that will fit on a single page.

I would also turn on Wrap Text (under the Home tab) so your cell contents aren't truncated.

 

[gilby101]

Is there a better way to do it?

Have any of the 4 replies assisted you?

 

[HDFan]

Whenever I try to export a spreadsheet as a PDF, it always comes out wrong

From where?