Documentation/FAQ/Calc/Formatting

doc

OOo

FAQ

{{{parttitle}}}

[[{{{PrevPart}}}|< Previous Section ]]

[[{{{NextPart}}}|Next Section >]]

• Project
  • Overview
  • Community Questions
  • Business and License
  • Issue Tracking
  • Source and Technology Questions
    • API Questions
    • Build Questions
    • Developer Questions
    • XML Questions
• General
• Installation
• Word Processing
  • Automatic Functions
  • Document Management
  • Formatting Pages and Docs
  • Formatting Text
  • Graphics, Frames & Objects
  • Indexes, Tables of Contents
  • Printing and Mail Merge
• Spreadsheets
  • Formatting Spreadsheets
  • Document management, file formats, compatibility
  • Printing Spreadsheets
  • Charts
  • Error handling, error messages
  • Miscellaneous questions
• Drawings
• Presentations
• Formula Editor
• Databases
  • MS Access
• Macros
• Platform-specific
  • Mac OS X 10.5 "Leopard"
  • Mac OS X 10.6 "Snow Leopard"

[[{{{PrevPage}}}|< Previous Page ]]

[[{{{NextPage}}}|Next Page >]]

Search the FAQs: <googlefaq/> This page has FAQs about formatting spreadsheets in OpenOffice 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 use styles and formatting?
• How can I create my own sort lists?
• Why are my notes not showing for cells?
• How can I use conditional formatting?
• I have a custom number format that I use, but Calc forgets it.
• 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 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 do I make a wide title cell extend across several columns in my spreadsheet?
• 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?

Add a new FAQ entry Instructions Do not ask questions here, but give answers. If you have a question to ask, go to the User Forum. Replace <FAQ_TITLE> part in the input box above by the title you would like to give the FAQ item and click Add New FAQ