Calc FAQ - Formatting Spreadsheets
From OpenOffice.org Wiki
This page has FAQs about formatting spreadsheets in OpenOffice.org Calc. 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.
- How do I insert superscript or subscript text in my spreadsheet?
- How can I use conditional formatting?
- How do I wrap text within a cell in my spreadsheet?
- How can I create a drop-down list that references a list of values to select from?
- How can I use a dot (.) as decimal sign instead of a comma?
- How can links to other workbooks, including vlookups, update dynamically?
- How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?
- How do I use styles and formatting?
- How do I format cells in Calc so that the rows number automatically?
- How can I create my own sort lists?
- I have a custom number format that I use, but Calc forgets it.
- How do I add additional strings or characters to cell contents?
- How are thick lines or borders created around my cells?
- How do I make a wide title cell extend across several columns in my spreadsheet?
- Is there a way to add times that total greater than 24 hrs?
- Some of the rows or columns in my spreadsheet are hidden. How do I see all rows or columns?
- 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 disable the capitalized letter at the beginning of cells in Calc?
- 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?
Add a new FAQ entryInstructions
|
