Spreadsheets_Formatting

=Spreadsheets - Formatting Data= include component="page" page="menu-Applications" editable="1" include component="page" page="menu-spreadsheets" editable="1" toc Here are some common formatting tricks that are buried in the formatting menus of Open Office: Always **use FILE - PAGE PREVIEW** to confirm that your formatting is working properly.


 * ==1. Borders==
 * Select a range of cells
 * Use FORMAT - BORDERS
 * Choose a 1.00pt line width
 * Choose a line arrangement second from the right

(Spreadsheets normally don't print the grids between cells unless you apply some borders) || ||
 * ==2. Landscape vs Portrait Pages==
 * FORMAT - PAGE
 * Choose LANDSCAPE if you need your spreadsheet to print out WIDE

|| || within Cells || ||
 * ==3. Text Wrap==
 * FORMAT - ALIGNMENT
 * WRAP TEXT
 * Widen the columns and expand the row height appropriately to accommodate the info
 * ==4. Header & Footer==


 * FORMAT - PAGE
 * Header - uncheck "Header On"
 * Footer - uncheck "Footer On" || [[image:Spreadsheets_Header.png]] ||
 * ==5. Freeze Titles==

You can "Freeze" the titles at the TOP and or LEFT sides of your spreadsheet so that they are always visible, even when you have long lists of data
 * Put the cursor in the TOP - LEFTmost cell that you want to scroll
 * From the dropdown menu, use WINDOW - FREEZE ||  ||