| <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> |