User manual COREL WORDPERFECT OFFICE 2002

[. . . ] Copyright © 2001 COREL CORPORATION and COREL CORPORATION LIMITED. For complete copyright information, please refer to the About section in the Help menu of the software. Book contents Section 1: Introduction . 5 29 145 251 339 399 Section 4: Corel Presentations 10 Section 5: Paradox 10 . . Section 6: CorelCENTRAL 10 Section 1 Introduction Table of contents: Introduction Welcome to WordPerfect Office 2002 . [. . . ] You can transpose rows to columns by selecting cells in a row instead of a column. Resizing rows and columns Quattro Pro lets you change the row height in a spreadsheet. Quattro Pro uses a default column width for all columns in a spreadsheet. This default width of an active spreadsheet is wide enough to display nine characters in the default font. Values that are wider than the cell display either in scientific notation or as a row of asterisks (*********), depending on the numeric format and width of the cell. You can automatically increase the column width as you type so that number values are always visible. 198 Quattro Pro 10 Columns whose widths you explicitly adjust are not controlled by the default width of the active spreadsheet. Before those columns can be affected by a change in the default width of the active spreadsheet, you must reset the column width of the active cell. You can also return row heights to the active cell default size, which is determined by the largest font used in the row. To change row height 1 Select a cell in each row you want to resize, or select the row borders. 4 In the Row options area, enable the Set height option and type a value in the box. 5 Enable one of the following options: Points Inches Centimeters You can also change row height by moving the pointer to the bottom edge of a row border until it changes to a double arrow, and dragging the double arrow to resize the row. You can select noncontiguous rows by pressing CTRL before selecting the rows. To change column width 1 Select a cell in each column you want to resize, or select the column borders. 4 In the Column options area, enable the Set width option and type a value in the box. 5 Enable one of the following options: Characters Inches Centimeters You can also change column width by moving the pointer to the right edge of a column border until it changes to a double arrow, and dragging the double arrow to resize the column. You can select noncontiguous columns by pressing CTRL before selecting the columns. To change the active spreadsheet default column width 1 Click Format } Sheet properties. 4 In the Unit area, enable one of the following options: Characters Inches Centimeters Editing and formatting a spreadsheet 199 You can also change the default column width by right-clicking a spreadsheet tab and clicking Sheet properties. To increase the column width while typing values 1 Click Tools } Settings. 2 In the list of categories, double-click Workspaces, Application, and click General. 3 Enable the Fit-As-You-Go check box. To restore the active cell default column width 1 Select a cell in each column whose width you want to restore to default. Click the Property button to access the Row/column tab. You can select noncontiguous columns by pressing CTRL before selecting the columns. To restore the active cell default row height 1 Select a cell in each row whose height you want to restore to default. Click the Property button to access the Row/column tab. You can select noncontiguous rows by pressing CTRL before selecting the rows. Resizing rows and columns to fit a specific cell To accommodate long entries, Quattro Pro lets you increase the column width to one character wider than the longest entry in a selection. You can also increase the row height to fit the tallest entry in a selection. You can adjust the row height and column width at the same time. To increase the column width to fit the longest entry 1 Select a column. You can also increase the column width to fit the longest entry in a selection of cells by selecting a partial column. 200 Quattro Pro 10 To increase the row height to fit the tallest entry 1 Select a row. You can also increase the row height to fit the tallest entry in a selection of cells by selecting a partial row. To adjust the column width and row height simultaneously 1 Select a cell. [. . . ] When a record is deleted in the PalmPilot, the record is deleted in CorelCENTRAL without an archive when you HotSync. The following table lists corresponding CorelCENTRAL and PalmPilot applications. CorelCENTRAL CorelCENTRAL Calendar and CorelCENTRAL Day Planner CorelCENTRAL Address Book CorelCENTRAL Memos CorelCENTRAL Calendar and CorelCENTRAL Day Planner 3Com PalmPilot Date Book Address Book Memo Pad To Do List For information about installing 3Com PalmPilot Desktop software, see the manufacturer's manual. Using 3Com PalmPilot with CorelCENTRAL Address Book You can only HotSync the default CorelCENTRAL Address Book with PalmPilot. If you want to HotSync an address book, you must first set it as the default address book. HotSyncing 3com PalmPilot and CorelCENTRAL 425 PalmPilot does not recognize CorelCENTRAL Address Book group, resource, or organization entries. [. . . ]