content/documentation/faqs/spreadsheet/index.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>
<title>Calc FAQs</title>
<p><a href="../../index.html">Documentation</a> / <a href="../index.html">User FAQ</a></p>
<h2>Spreadsheet FAQ Index Page</h2>
<ul>
  <li><a href="001.html">001</a> - How do I open a tab-delimited file in OpenOffice.org Spreadsheet? What if I have a different type of delimiter?</li>
  <li> <a href="002.html">002</a> - I see '###' in a cell that formerly held data. How can I see my data again?</li>
  <li> <a href="003.html">003</a> - How do I wrap text within a cell in my spreadsheet?</li>
  <li> <a href="004.html">004</a> - How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?</li>
  <li> <a href="005.html">005</a> - I don't want a capitalized letter at the beginning of a phrase in Calc. What should I do?</li>
  <li><a href="006.html">006</a> - How do I freeze/split the first rows and the first columns so that they remain visible when I scroll through my spreadsheet?</li>
  <li><a href="007.html">007</a> - How do I print my spreadsheet correctly?</li>
  <li><a href="008.html">008</a> - How do I make a wide title cell extend across several columns in my spreadsheet?</li>
  <li><a href="009.html">009</a> - How do I rotate a column title so that it fits above my very narrow column?</li>
  <li><a href="010.html">010</a> - How do I create a chart in a spreadsheet that is automatically updated when the data is changed?</li>
  <li><a href="011.html">011</a> - How do I protect cells in my spreadsheet?</li>
  <li><a href="012.html">012</a> - How do I output my spreadsheet data as an ASCII, delimited text file?</li>
  <li><a href="013.html">013</a> - Some of the rows in my spreadsheet are hidden. How do I see all the rows?</li>
  <li><a href="014.html">014</a> - How do I format cells in OpenOffice.org Spreadsheet so that the rows number automatically?</li>
  <li><a href="015.html">015</a> - What do each of the error codes (Err:NNN) in OpenOffice.org spreadsheets mean?</li>
  <li><a href="016.html">016</a> - How can I use cells from different Calc files?</li>
  <li><a href="017.html">017</a> - How I change the order of sheets in my spreadsheet?</li>
  <li><a href="018.html">018</a> - How can I rename a sheet?</li>
  <li><a href="019.html">019</a> - How is a variable date inserted into a spreadsheet cell?</li>
  <li><a href="020.html">020</a> - How are thick lines or borders created around my cells?</li>
  <li><a href="021.html">021</a> - How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?</li>
  <li><a href="022.html">022</a> - A large OpenOffice.org spreadsheet was converted from another application. Some of my rows are missing! What happened?</li>
  <li><a href="023.html">023</a> - What is the maximum number of cells in an OpenOffice.org spreadsheet?</li>
  <li><a href="024.html">024</a> - How do I insert superscript or subscript text in my spreadsheet?</li>
  <li><a href="025.html">025</a> - Is it possible to open an Excel file that is protected by a password in Calc?</li>
  <li><a href="026.html">026</a> - How can I use decimal signs (dots) instead of commas to display rational figures?</li>
  <li><a href="027.html">027</a> - I want to select two cells that are not adjacent, but holding down the CTRL key does not seem to work. How can I perform this action?</li>
  <li><a href="028.html">028</a> - How can I create my own sort lists?</li>
  <li><a href="029.html">029</a> - Is there any way to merge a text file with separated fields (*.txt, *.csv) into a Calc file?</li>
  <li><a href="030.html">030</a> - How can I wrap text within a cell?</li>
  <li><a href="031.html">031</a> - If a cell is centre-justified, and the text is wider than the cell, it automatically left-justifies. Can I fix this?</li>
  <li><a href="032.html">032</a> - In MS Excel I can center my text so that the text will flow both to the left and right if the cells are empty; how can I do this in Calc?</li>
  <li><a href="033.html">033</a> - How do I use styles and formatting?</li>
  <li><a href="034.html">034</a> - Can I use a spreadsheet file with more than 32,000 rows?</li>
  <li><a href="035.html">035</a> - My formula from an Excel worksheet doesn't work!</li>
  <li><a href="036.html">036</a> - Why does Calc refuse to open my text file?</li>
  <li><a href="037.html">037</a> - How do I add trailing characters to a cell?</li>
  <li><a href="038.html">038</a> - How are notes within cells displayed?</li>
  <li><a href="039.html">039</a> - Why does deleting filtered rows remove other rows too?</li>
  <li><a href="040.html">040</a> - How can I start Calc instead of Writer?</li>
  <li><a href="041.html">041</a> - Why does Calc print out all the sheets in the file?</li>
  <li><a href="042.html">042</a> - How can I print some, but not all, of the cells on a sheet?</li>
  <li><a href="043.html">043</a> - How do I get Sheet1 to print as portrait and Sheet2 to print as landscape?</li>
  <li><a href="044.html">044</a> - I have a custom number format that I use, but Calc forgets it.</li>
  <li><a href="045.html">045</a> - How can I use conditional formatting?</li>
  <li><a href="046.html">046</a> - What is the fastest way to copy a calculation to all rows?</li>
  <li><a href="047.html">047</a> - Where can I find definitions for the error codes?</li>
  <li><a href="048.html">048</a> - Why do I see the formula text and not the result of the formula?</li>
  <li><a href="049.html">049</a> - Is there a way to add times that total greater than 24hrs?</li>
  <li><a href="050.html">050</a> - Where can I find more documentation for Calc?</li>
  <li><a href="051.html">051</a> - These automatisms suck!!
  <li><a href="052.html">052</a> - How to get proper Calc Help files for OpenOffic.org 2.0.1 for Windows?
</li>
  <li><a href="053.html">053</a> - How do I extend the range of data shown in my chart after I add new data to my spreadsheet?</li>
</ul>
<p><a href="../../index.html">Documentation</a> / <a href="../index.html">User FAQ</a></p>