content/documentation/faqs/spreadsheet/007.html

<meta http-equiv="REFRESH" content="10;url=http://wiki.services.openoffice.org/wiki/Documentation/FAQ">
<h3>This page is outdated. You will be redirected to <a href="http://wiki.services.openoffice.org/wiki/Documentation/FAQ">http://wiki.services.openoffice.org
/wiki/Documentation/FAQ</a> shortly.</h3>
<div style="margin-bottom: 10em;"></div>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="006.html" accesskey="p">Previous</a>-<a href="008.html"
 accesskey="n">Next</a></p>
<h3>How do I print my spreadsheets?
</h3>
<p>In general, the best way to print large spreadsheets
is to first preview the print output, then adjust the print settings to
arrive at the desired effect. The following mini-procedures explain the
main options for printing spreadsheets.</p>
<p><b>Previewing the print area:</b></p>
<ul>
  <li>With the spreadsheet open, go to <b>File &gt; Page Preview</b>
in the drop-down menus.</li>
  <li>In the window that appears, use the navigation buttons on the
tool bar to view the print. If the spreadsheet is
too large for one page, some columns may appear on additional pages.</li>
  <li>To close the preview window, click the <b>Close Preview</b>
button
to the right of the navigation buttons on the toolbar.</li>
  <li>Make adjustments to the print settings, then preview again.
Repeat until the print displays in the desired format.</li>
</ul>
<p><b><i>Note:</i></b> This command will allow you to see
the current page number assignments for the data that you want to
print. This is
especially useful when only a portion of the spreadsheet is to be
printed, or when several print ranges are associated with one Calc file.</p>
<p><b>Formatting the page:</b></p>
<ul>
  <li>With the spreadsheet open, go to <b>Format &gt; Page...</b> in
the
drop-down menus. </li>
  <li>In the dialog that appears, select the <b>Page</b> tab.</li>
  <li>Set the paper size.</li>
  <li>Specify the Orientation of the page: click on the
checkbox next to Portrait or Landscape.</li>
  <li>Adjust the margins, if needed.</li>
  <li>Set the table alignment to align the table to the page.</li>
  <li>Click <span style="font-weight: bold;">OK</span>, or click other
tabs in this box to acess more formatting options.<br>
  </li>
</ul>
<p><b>Adjusting the page breaks:</b></p>
<ul>
  <li>With the spreadsheet open, select <b>View &gt; Page
Break Preview</b>.</li>
  <li>Place the cursor exactly on top of one of the (blue) page edge
lines, then drag each edge to adjust the page boundaries as desired.</li>
  <li>To toggle this view off, select <b>View &gt; Page
Break Preview</b>.</li>
</ul>
<p><b><i>Note:</i></b> If everything appears gray, this means that
no print ranges are defined. If a print range is defined, the
printing area will show up with a white background with a blue outline
at the page boundary. A gray 'Page N', where 'N' is the page sequence
number <i>for the sheet</i>, will appear in the middle of the print
area. If no range is defined for printing, follow the instructions
below.</p>
<p><b>Setting the area to be printed:</b></p>
<ul>
  <li>Go to the desired sheet.</li>
  <li>Click and drag to select (highlight) the area of the sheet to be
printed.</li>
  <li>In the drop-down menus, go to <b>Format &gt; Print Ranges &gt;
Add</b>.</li>
  <li>Repeat the above steps for each sheet of the file
to be
printed.</li>
</ul>
<p><b>Adjusting the printout to fit onto one page:</b></p>
<ul>
  <li>With the spreadsheet open, select <b>Format &gt; Page...</b></li>
  <li>In the dialog that appears, select the <b>Sheet</b> tab.</li>
  <li>In the lower right corner of the dialog, there is a <b>Reduce/enlarge
printout</b> scale control. Enter a value that you think will make
the data fit on the page.</li>
  <li>Click <b>OK</b>.</li>
  <li>Use <b>Page Preview</b> (instructions above) to see a
preview of what will print. Readjust if necessary.</li>
</ul>
<p><b>Adjusting the maximum number of pages on which the print
should fit:</b></p>
<ul>
  <li>With the spreadsheet open, select <b>Format &gt; Page...</b></li>
  <li>In the dialog that appears, select the <b>Sheet</b> tab.</li>
  <li>At bottom of the dialog there is a scale control labeled, <b>Fit
printout on number of pages</b>. Click the checkbox
next to
it; then enter the desired number of pages for the printout.</li>
  <li>Click <b>OK</b>.</li>
  <li>Use <b>Page Preview</b> (instructions above) to see a
preview of what will print. Readjust if necessary.</li>
</ul>
<p><b>Printing only a portion of the spreadsheet (a range of rows or
columns):</b></p>
<ul>
  <li>In the spreadsheet where the data lives, click and drag the mouse
over the cells to select (highlight) the rows or
columns to be
printed.</li>
  <li>Select <b>Format &gt; Print Ranges</b>.</li>
  <li>In the print dialog that appears, click the checkbox next to <b>Edit...</b>
at lower left.</li>
  <li>Click <b>OK</b>.</li>
</ul>
<p><b><i>Note:</i></b> Printing a selected range of data is also
controlled by print scaling. If the data selected does not fit on the
desired number
of pages, adjust the Scale using either of the scaling procedures above
(scale by percentage or by number of pages allowed).</p>
<p><b>Editing the print range:</b></p>
<ul>
  <li>With the spreadsheet open, select <b>Format &gt; Print Ranges
&gt; Edit</b>.</li>
  <li>In the print dialog that appears, look at the <b>Print range</b>
setting. It is probably set to <b>user
defined</b> and shows a range of cells.</li>
  <li>Adjust the cell definition in the range of cells, or select <b>None
    </b> to clear the print range.</li>
  <li>Click <b>OK</b>.</li>
  <li>If there are no settings, or they are cleared, use one of the
other methods
shown to set your print ranges.</li>
</ul>
<p><b>Printing a spreadsheet in the middle of the paper:</b></p>
<ul>
  <li>With the spreadsheet open, select <b>Format &gt; Page...</b></li>
  <li>In the dialog that appears, select the <b>Page</b> tab.</li>
  <li>In the <b>Table alignment</b> section, select (or deselect as
desired) the
boxes next to <b>Horizontal</b> and <b>Vertical</b>. A
visual of the
table alignment settings will show in the small graphic on the same
page as
these parameters.</li>
</ul>
<p><b>For more information:</b></p>
<ul>
  <li><a
 href="http://documentation.openoffice.org/HOW_TO/spreadsheet/calc5_EN.html">How
to Set the Printing Settings</a> </li>
</ul>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="006.html" accesskey="p">Previous</a>-<a href="008.html"
 accesskey="n">Next</a></p>