tailieunhanh - Getting Started with Open Office .org 3 part 15

Getting Started with Open Office .org 3 part 15. 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 | Deleting sheets Sheets can be deleted individually or in groups. Single sheet Right-click on the tab of the sheet you want to delete and select Delete Sheet from the pop-up menu or click Edit Sheet Delete. Multiple sheets To delete multiple sheets select them as described earlier then either right-click over one of the tabs and select Delete Sheet from the popup menu or click Edit Sheet Delete from the menu bar. Renaming sheets The default name for the a new sheet is SheetX where X is a number. While this works for a small spreadsheet with only a few sheets it becomes awkward when there are many sheets. To give a sheet a more meaningful name you can Enter the name in the name box when you create the sheet or Right-click on a sheet tab and select Rename Sheet from the pop-up menu and replace the existing name with a better one. Sheet names can contain almost any characters with the exception of those characters not allowed in MS Excel. This Note restriction has been artificially created for compatibility reasons. Attempting to rename a sheet with an invalid name will produce an error message. Viewing Calc Using zoom Use the zoom function to change the view to show more or fewer cells in the window. For more about zoom see Chapter 1 Introducing OOo . Freezing rows and columns Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of a spreadsheet or both. Then when Chapter 5 Getting Started with Calc 141 scrolling around within the sheet any frozen columns and rows remain in view. Figure 105 shows some frozen rows and columns. The heavier horizontal line between rows 3 and 14 and the heavier vertical line between columns C and H denote the frozen areas. Rows 4 through 13 and columns D through G have been scrolled off the page. Because the first three rows and columns are frozen into place they remained. Figure 105. Frozen rows and columns You can set the freeze point at one row one column or both a row and a column as in Figure