Difference between revisions of "Documentation/FAQ/Calc/Formatting"
From Apache OpenOffice Wiki
< Documentation | FAQ | Calc
(New page: Category:User FAQ {{Documentation/FAQTOC}} {{DISPLAYTITLE: Calc FAQ - Formatting Spreadsheets}} This page has FAQs about formatting spreadsheets in OpenOffice.org Calc. <DPL> categ...) |
|||
Line 7: | Line 7: | ||
<DPL> | <DPL> | ||
category=Documentation/FAQ/Calc/Formatting | category=Documentation/FAQ/Calc/Formatting | ||
+ | ordermethod=counter | ||
+ | order=descending | ||
replaceintitle=/Documentation.*\//, | replaceintitle=/Documentation.*\//, | ||
secseparators=<br> | secseparators=<br> | ||
Line 21: | Line 23: | ||
</inputbox> | </inputbox> | ||
</td></tr></table> | </td></tr></table> | ||
+ | |||
+ | This list is ordered by popularity. The most popular FAQs are at the top. But also have a look at the bottom to find any new entries. |
Revision as of 09:30, 19 November 2008
This page has FAQs about formatting spreadsheets in OpenOffice.org Calc.
- How can I create a drop-down list that references a list of values to select from?
- How do I insert superscript or subscript text in my spreadsheet?
- How do I wrap text within a cell in my spreadsheet?
- How can I use a dot (.) as decimal sign instead of a comma?
- How can I use conditional formatting?
- How can links to other workbooks, including vlookups, update dynamically?
- How do I add additional strings or characters to cell contents?
- How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?
- How are thick lines or borders created around my cells?
- How do I format cells in Calc so that the rows number automatically?
- Is there a way to add times that total greater than 24 hrs?
- How can I create my own sort lists?
- How do I use styles and formatting?
- How do I make a wide title cell extend across several columns in my spreadsheet?
- I have a custom number format that I use, but Calc forgets it.
- Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?
- How do I disable the capitalized letter at the beginning of cells in Calc?
- Can I center my text so that the text will flow both to the left and right if the cells are empty?
- How do I rotate a column title so that it fits above my very narrow column?
- How are notes within cells displayed?
- Why are my notes not showing for cells?
This list is ordered by popularity. The most popular FAQs are at the top. But also have a look at the bottom to find any new entries.