blob: 5168ca5f4bd2c26525d7d8515147fa2098a7fd52 [file] [log] [blame]
<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="013.html" accesskey="p">Previous</a>-<a href="015.html"
accesskey="n">Next</a></p>
<h3>How do I format cells in OpenOffice.org Spreadsheet
so that the rows number automatically?</h3>
<p>One method (this example assumes that you wish to put your row
numbers in column A):</p>
<ol>
<li>Enter the formula <b>=row(a1)</b> in cell A1.</li>
<li>Extend the cell by dragging the bottom right corner all the way
down column A.</li>
</ol>
<p><b>Note:</b> If you add or insert new rows, you will have to copy
the formula to the new cells.</p>
<p><a href="../../index.html">Documentation</a> / <a
href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
href="013.html" accesskey="p">Previous</a>-<a href="015.html"
accesskey="n">Next</a></p>