content/documentation/faqs/spreadsheet/006.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="005.html" accesskey="p">Previous</a>-<a href="007.html"
 accesskey="n">Next</a></p>
<h3>How can I see the row and column captions as I scroll through a
sheet that is larger than my display?</h3>
<p>There are two ways to obtain this result:</p>
<p>Mode 1 (with a single row or column caption): <b>Freeze</b> the
caption.</p>
<ol>
  <li>Click on the cell just below and to the right of the row and
column that will contain your caption.</li>
  <li>From the drop-down menus, select <b>Window &gt; Freeze</b>. If
you have either row captions or column labels, you can create a cross
freezing by clicking on the uppermost left side cell that does not
contain a caption. For example, in a sheet with single row and column
captions, choose the B2 cell. The position of all cells above and to
the left of the cell where the Freeze was activated will be frozen.</li>
</ol>
<p>Mode 2 (with multiple row or column captions): <b>Split</b> the
sheet. </p>
<ol>
  <li>Click on the cell just below and to the right of the row and
column that you want to contain your caption.</li>
  <li>From the drop-down menus, select <b>Window &gt; Split</b>. The
sheet window will be split. The result is different from Mode 1 because
you can scroll all sections of the split window, showing the caption
according to your needs. </li>
</ol>
<p>It is also possible to split a sheet window in another way.</p>
<ol>
  <li>At the top of the right scroll bar and at the right of the bottom
one, you can see little black lines. When the mouse is over one of
these zones, the mouse pointer changes into a dragging icon. When this
icon shows, click and hold down the left mouse button to display a
border line in the grid of cells.</li>
  <li>With the mouse, drag the line on the grid to the row or column
that will contain your caption.</li>
  <li>Release the mouse button. The sheet will be split at this border.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="005.html" accesskey="p">Previous</a>-<a href="007.html"
 accesskey="n">Next</a></p>