TËCHNOLÔG¥ FÖR ALL

Technologyforall.com
Lawrence, Kansas 66047
Phone: (785)842-6136

HOME  HOME  | FAQ | DISCUSSION | ABOUT US  |  RESUME POSTING  | Computer Jobs | Software Info |  Tech-Support Directory for Computer Companies

Most cell properties affect the appearance of cell entries or of rows or columns. To set cell properties directly,

1. Select the cells you want to affect.
2. Then Click on the button.

You can change many properties at the same time. You can see an example of what your changes will look like before you click OK.

The coordinates of the selected cells appear in the title bar. These helps you confirm which cells you are affecting.

To set the numeric format for cells,

1. Select the cells you want to format.
2. Then Click on the button.
3. Click the Numeric Format tab.
4. Choose one of the formats listed.

If the format you chose allows a variable number of decimal places, an edit field appears. Type a number from 0 to 15 (the default is 2).

• If you click General, numbers display exactly as you enter them (unless the column width is too narrow).
• If you click Currency, choose the country whose currency symbol you want to use.
• If you click Date, choose a specific date format.
• If you click Time, choose a specific time format.
• If you click User Defined, you can choose from a list of formats you create yourself.

• By default, when you enter a number, the column widens to fit the number (unless the number is interpreted as General format). If columns are not expanding when you enter numbers, click Tools Settings General Fit-As-You-Go.
• All numeric formats leave the cell values intact; they affect only the way values are displayed.

To choose a font,

• Select the cells whose font you want to change.
• Then Click on the button.
• Click the Cell Font tab.
• Choose the Font face, Font size, and options you want to use.

Tips:

• You can also choose a font from the Property Bar, which appears above the column letters.
• If a font has a TT (TrueType) or a (ATM) symbol beside it, text in that font will appear in print just as it does onscreen. Fonts with a printer symbol will print on your printer, but may not appear in the correct font onscreen. Fonts without a symbol appear accurately onscreen, but may not appear in correct font when printed.
• If you enlarge or reduce the font size, the row height changes to display the tallest letters in the row.
• To add a line or double underline for totals or grand totals, click the cell, Then Click on the button. Cell Font Single Line or Double Line under Accounting Style.

To align data in cells,

1. Select the cells you want to align.
2. Click on the Property Bar.
3. Click an option. (You can point to an option to see what it does: General, Left, Center, Right, Center Across Cells to span several cells, or Indent.)

1. Click .
2. Click the Alignment tab.
3. Select any options.

To draw lines and boxes,

To choose from predefined lines and boxes,

1. Select the cells that you want to draw lines around and between.
2. Click on the Property Bar, and choose a line or box drawing.

To create your own line combination,

1. Select the cells, then click Border/Fill.
2. Click a line segment on the left. Use Shift+click to select multiple line segments.
3. Click a border type or border color, or apply the chosen line type in a preset pattern by clicking one of the three pattern boxes.

Tips:

• To remove lines when you are creating your own lines, click the lines you want to remove in the sample, then click the No Line type.
• If you change your mind as you are creating your own lines, click the line you recently changed, then click the No Change line type. It returns the line to the line type in effect when you last clicked OK. To cancel all changes, click Cancel.

To change the color of text,

1. Select the cells your want to change, then click .
2. Choose the color you want. If you already changed the cell's shading, make sure the Text Color setting will contrast enough to be visible.

Tips:

• If text does not appear on your printout, you may need to choose a darker color. Light colors print as white on some printers.
• With most color choices, you need to deselect the cells to see the new shading. This is because selected cells are shown in reverse color.
• To change the colors available, click Format Notebook Palette. If you create a new color for the palette that is dithered and later choose it for the Text Color, your text will appear in a substitute, nondithered color. You can use dithered colors for other elements besides text and drawn lines.

To set column width to an exact size,

1. Select any cell in each column you want to resize, or select their borders. You can also select noncontiguous columns.
2. Click .
3. Click the Row/Column tab.
4. Click Set Width. Then, click Characters, Inches, or Centimeters, and enter the number you want in the Column Width edit field.

• To return column width to the default, click Reset Width instead of Set Width.
• To resize contiguous columns based on the longest entry instead of an exact measurement, click on the Toolbar. If entire or partial columns are selected, the width is based on the longest entry in the selection. If a single-row (or just one cell) is selected, the width is based on the longest entry in that row and all cells below it.

• The setting of the sheet Default Width determines the default column width. Columns whose widths you have explicitly adjusted (using Format QuickFit, the mouse, or the Column Width property) are not controlled by the Default Width property.
• If a column you are adjusting contains a long entry that spills over into blank cells to the right, and you do not want the column adjusted to that cell entry's length, specify more than one row but that stops short of cells.

To hide rows or columns,

1. Select the rows or columns to hide.
2. Right-click the rows or columns, then click Hide.

• To hide all rows and columns on a notebook sheet, select a cell in each column or row you want to hide, then follow the same steps.
• You can also click Format Selection Row/Column.

To reveal hidden rows or columns,

1. Select an area containing cells on both sides of the hidden area.
2. Click .
3. Click the Row/Column tab.
4. Click Reveal under Column options or Row options.

Tip:

• You can also reveal a single hidden row or column with the mouse. To reveal a hidden column, place the mouse pointer slightly to the right of the hidden column’s border, then drag. For a hidden row, drag from just below the hidden row’s border. The hidden row or column is revealed and sized as you drag. For example, you can use this technique to reveal row 1 and column A when they are hidden.

To resize rows to exact sizes,

1. Select a row.
2. Click .
3. Click the Row/Column tab.
4. Click Set height, then click Points, Inches, or Centimeters, and enter the number you want in the Height Options edit field.

Tips:

• To return the row height to the default (as determined by the largest font used in the row), click Reset Height.
• You can also click Format Selection Row/Column.

To unprotect cells on a sheet,

1. Select the cells.
2. Click .
3. Click the Constraints tab.
4. Set Cell Protection to Unprotect.

• The Cell Protection option works with the sheet Protection property. If you are creating a data entry form for other users, protect the entire sheet, then unprotect the cells you want users to edit.

Templates from KMT Software, Inc.

Some of the templates in Corel Quattro Pro were developed by KMT Software, Inc. View the ABOUT.WB3 template to learn about other Corel Quattro Pro and Corel WordPerfect products. If you are interested in having KMT Software, Inc. develop templates for your organization, call 1-508-371-2052 or send e-mail to sales@kmt.com. For more information about KMT Software, Inc., visit the KMT Software, Inc. web site at www.kmt.com.

401k Planner

Use this template to forecast the growth in value of your 401K plan and to project the monthly income you will receive from the plan upon your retirement. It also compares the wealth accumulation in the 401K plan in contrast to the growth of a taxable savings plan. The forecasted monthly income during retirement is pre-tax. Of course, your after-tax retirement income will depend on the marginal tax rates at that time.

To use this template, click File New, then select the template from the list.

7-Year Balloon Loan

Use this template to calculate monthly loan payments and prepare an amortization schedule for a seven-year balloon loan. A balloon loan requires a large final payment at some future date. The advantage of such an arrangement is that the borrower makes payments based on a traditional mortgage term -- such as 15 or 30 years -- at an interest rate that reflects the typically lower annual rate of a shorter-term loan (7 years). The loan amortization is any period that you choose and affects the monthly payment you will make during the seven years. You can lower the monthly payment by entering a longer amortization period.

To use this template, click File New, then select the template from the list.

Ad Media Expenditures

This template can be used to summarize actual advertising expenditures or to plan expenditures for an upcoming 12-month period. It is made up of three common advertising media: print, broadcast, and direct mail. The totals for each category, totals for the year, and the grand total for the advertising expenditures for a 12-month period are calculated. Enter the name of the first month in the first column, and the remaining month names will automatically adjust.

To use this template, click File New, then select the template from the list.

Added Payment Mortgage

Use this template to analyze the impact of making additional payments on principal. By making additional payments, you can reduce both the interest cost and life of a mortgage loan. The template assumes that you will make the additional payment each month with your normal payment. By doing so, your additional payment is immediately applied to principal and therefore accelerates the payoff of the loan balance. Check with your lender before devising an additional payment strategy to be sure that no prepayment penalty will be incurred.

To use this template, click File New, then select the template from the list.

HOME  | FAQ | DISCUSSION | ABOUT US  |  RESUME SUBMISSION   |  | FAQ | DISCUSSION | ABOUT US  |  RESUME POSTING   | Computer Jobs | Software Info |  Tech-Support Directory for Computer Companies