content/documentation/faqs/spreadsheet/004.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="003.html" accesskey="p">Previous</a>-<a href="005.html"
 accesskey="n">Next</a></p>
<h3>How I do select a row (or rows) in my spreadsheet
to repeat on every page when printed?</h3>
<p>Follow these steps:</p>
<ol>
  <li>Open Calc.</li>
  <li>Select the row(s) to repeat.</li>
  <li>Select <b>Format &gt; Print Ranges &gt; Edit</b> from the
pull-down menus.</li>
  <li>Change <b>Rows to repeat</b> from <b>- none -</b> to <b>- user
defined -</b> via the drop-down menu.</li>
  <li>The row numbers can be set a couple of ways:
    <ul>
      <li>Enter the row number (e.g. $4 for row 4).</li>
      <li>Click on the icon to the right of the input bar, then select
a cell on the desired row from the spreadsheet. Multiple rows can be
specified dragging your mouse across a range of cells.</li>
      <li>Type the range into the <b>Rows to repeat</b> input bar.
Place a colon between the starting cell and the ending cell to show a
range.</li>
    </ul>
  </li>
  <li>Click <b>OK</b>.</li>
</ol>
<p>The row(s) specified here will be repeated on each print. You will
not see a visual change in the spreadsheet, only in the printed copies.
Use <b>File &gt; Print Preview</b> to preview pages before printing.</p>
<p><b>For more information:</b></p>
<p>Go to <b>Help &gt; Contents &gt; Index</b> and type <b>print ranges</b>.
Double-click on list items there to bring up the corresponding help
pages.</p>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="003.html" accesskey="p">Previous</a>-<a href="005.html"
 accesskey="n">Next</a></p>