content/documentation/faqs/spreadsheet/021.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="020.html" accesskey="p">Previous</a>-<a href="022.html"
 accesskey="n">Next</a></p>
<h3>How do I insert a page number in the form of 'Page
1 of N' on each page of a spreadsheet?</h3>
<p>Page numbers can be inserted into the header or footer sections of a
spreadsheet. These will be visible only in the Page Preview mode and on
the print. The page numbers will not be visible on, nor are they
related to, the calc sheets themselves. The page numbers reflect the
defined print areas of the workbook. To insert page numbers, follow
these instructions:</p>
<ul>
  <li>From the pull-down menus, select <b>Edit &gt; Headers &amp;
Footers...</b></li>
  <li>Select either the Header tab or the Footer tab.</li>
  <li>Click in the area where the page number blurb will display (Left,
Center, or Right) to place the cursor inside the box.</li>
  <li>Type <b>Page</b>, then add one space character.</li>
  <li>The available data fields are represented by a row of icons below
the left, center, and right input areas. Click on the document icon
with ONE number sign [ # ] to insert the page number field. </li>
  <li>Type a space, <b>of</b>, and another space.</li>
  <li>Click on the document icon with TWO number signs [ ## ] to insert
the page total field.</li>
  <li>Click <b>OK</b>.</li>
</ul>
<p><b>Note:</b> The data fields available int the header and footer
settings are the only data fields and formats available in spreadsheets.</p>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="020.html" accesskey="p">Previous</a>-<a href="022.html"
 accesskey="n">Next</a></p>