Getting Started with Open Office .org 3 part 16. This Manual Book is for anyone who wants to get up to speed quickly with the latest version . “GETTING STARTED WITH ″ introduces all software programs of the OpenOffice bundle: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor) and Base (database). This book was written by volunteers from the community working through and is distributed under the CreativeCommon Attribution Licence | Replacing all the data in a cell To remove data and insert new data simply type over the old data. The new data will retain the original formatting. Changing part of the data in a cell Sometimes it is necessary to change the contents of cell without removing all of the contents for example if the phrase See Dick run is in a cell and it needs to be changed to See Dick run fast. It is often useful to do this without deleting the old cell contents first. The process is the similar to the one described above but you need to place the cursor inside the cell. You can do this in two ways. Using the keyboard After selecting the appropriate cell press the F2 key and the cursor is placed at the end of the cell. Then use the keyboard arrow keys to move the cursor through the text in the cell. Using the mouse Using the mouse either double-click on the appropriate cell to select it and place the cursor in it for editing or single-click to select the cell and then move the mouse pointer up to the input line and click into it to place the cursor for editing. Formatting data The data in Calc can be formatting in several ways. It can either be edited as part of a cell style so that it is automatically applied or it can be applied manually to the cell. Some manual formatting can be applied using toolbar icons. For more control and extra options select the appropriate cell or cells right-click on it and select Format Cells. All of the format options are discussed below. All the settings discussed in this section can also be set as a part of the style using the Styles and Formatting window. See Note Chapter 10 Using Styles in Calc in the Calc Guide for more information. Chapter 5 Getting Started with Calc 151 Formatting multiple lines of text Multiple lines of text can be entered into a single cell using automatic wrapping or manual line breaks. Each method is useful for different situations. Using automatic wrapping To set text to wrap at the end of the cell right-click on the cell .
