47. Print a Spreadsheet
40 Create a New Spreadsheet 41 Open an Existing Spreadsheet 62 Set Up Calc Page Formatting Once you're done creating your spreadsheet, you'll want to print it to paper. Calc supports the standard printing options that most Windows programs support. If your document has color charts and you have a color printer, the charts will print just fine. Otherwise, the charts will print in shades of black and gray (and still look fine!).36 Save a Document as a PDF File for more information about PDF files.
[View full size image]

- Top to bottom, then right
Prints the sheet down one column at a time. - Left to right, then down
Prints the sheet across one row at a time. - Spreadsheet elements
Requests the printing of any or all of the following: column and row headers, the sheet's grid, notes, graphics, charts, formulas (instead of their results), and zero values (instead of blanks). - Scaling
Use this option to reduce the size of the printout to fit on one page (if the sheet is small enough) and to specify exactly how many pages you want Calc to attempt to print the sheet to. The scaling options often enable you to squeeze a sheet that's larger than a single page onto one printed page.