content/documentation/faqs/spreadsheet/008.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="007.html" accesskey="p">Previous</a>-<a href="009.html"
 accesskey="n">Next</a></p>
<h3>How do I make a wide title cell extend across
several columns in my spreadsheet?</h3>
<p>Follow these instructions:
</p>
<ol>
  <li>Select the multiple cells in which the title is to appear. Do
this by clicking in the first cell, then hold down the mouse button and
drag the selection box across the last cell of your chosen area.</li>
  <li>From the pull-down menu, select <b>Format &gt; Merge Cells &gt;
Define</b>. The cells selected in the step above now appear as one.</li>
</ol>
<p>Many times, the title or merged-area created needs the text centered
or aligned within it. To do this: </p>
<ol>
  <li>Click on the title cell to select it.</li>
  <li>From the pull-down menu, select <b>Format &gt; Cells</b>.</li>
  <li>On the dialog that appears, select the <b>Alignment</b> tab.</li>
  <li>Both the <b>Horizontal</b> and <b>Vertical</b> alignment of
text can be set here, where other adjustments to cell text are allowed
as well. The alignments can also be defined more simply by clicking on
the alignment buttons on the toolbar above the spreadsheet.</li>
</ol>
<p><a href="../../index.html">Documentation</a> / <a
 href="../index.html">User FAQ</a> / <a href="index.html">Calc</a> / <a
 href="007.html" accesskey="p">Previous</a>-<a href="009.html"
 accesskey="n">Next</a></p>