Cell Height and Width

To change the height and width of a cell you have two options.

1.

Place the mouse pointer on the line between the cell headings (between A and B
for columns or between 1 and 2 for rows). The arrow will turn into a heading
pointer and when you click and drag using this tool you can resize the column or
row. You can select more than one column or row at the same time by clicking and
dragging on the heading boxes (which will highlight the entire column or row) and
when you resize the cells will be the same size.

2.

First, select the cells you want to change. From the menu choose FORMATROW or
COLUMNHEIGHT or WIDTH. You can type in the desired size for the row or use the
default.

Text Alignment in a cell

The text in a cell can be aligned to the left, right, center and full justify.

First, highlight the cells you wish to align. From the Menu choose FORMAT CELLS and
choose the alignment you want.

You also have a choice of Text wrap which will wrap the text in the cell to more than
one line. You will need to change the height of the row to see all the text.

Copy cells from one location to another

When you are copying cells you are copying the information in the cell. There are
three ways of doing this

1.

2.

Highlight the cells and Copy and Paste the information from one cell to another.

Have the information duplicated in another cell by typing in a formula in the
destination cell. This is helpful when you want information in to separate
location of a spreadsheet.

Number format in a cell

The format of a cell's number can be for currency, percents, dates and times. The options
are available when you choose FORMAT CELLS from the Menu. Remember to highlight the
cells where you want to change the number format.

General is the default. Currency will show the dollar signs and cents. Percent will
change a decimal number into a percent (1 will show as 100% - .50 will show as 50%)

Cell Grid, Columns headings and Row headings

Excel defaults to printing withoutgrids lines. If you want to show the grid you must
from the Menu choose FILE PAGE SETUPand choose the SHEET tab. Click on Print Grid
lines and Row and Column headings if you want them to show. You will only see the
changes in the print preview or the printed copy.

You can also set the print range by clicking on the Print Area button and click and drag
through the area you want printed.

Also you can have the rows with titles repeated at the top of each page and the
Columns repeated on the left of each page.

This menu also changes the paper size and orientation and the margins as well as
insert headings and footers.

Graph of a range of cells and Graph Customization

5. Set the range of the data and if the data will presented in the Columns or Rows
format

6. Set the titles of your chart as well as the titles for the X and Y Axes

Set the presentation of the information on the Axes, the major and minor Grid lines
and the placement of the Legend. Also whether there will be data labels and whether
the data table will be shown with the chart.

7.

Finally set the Chart Location - on a new sheet in Excel or on an existing sheet.

8. Customize the colors of the chart by selecting the data in the legend and using the
fill icon from the menu to choose a different color.

Click on any portion of the chart to select and change that component (Font size, color
or style)

Calculation of a range of cells

All formulas to calculate in a spreadsheet start with an
equal sign. Formulas are available from the Menu choose
INSERT FUNCTION. Excel Assistant explains the various
capabilities of the formulas and the arguments, or values
you supply to a function so that it can perform a
calculation.
Use a formula that refers to a range of cells. The range of
cells is enclosed in parentheses and separated by two
periods. The range can be in one column or row or include
more than one column or row. When a range crosses from
one column to another it includes all the cells between the
two cell addresses, a1 to c3 would include a1 to a3, b1 to
b3 and c1 to c3.

Relative and Absolute cell address

A relative cell address is the location of a cell relative to the location of the cell
containing the formula.
For example - if a formula in cell B2 contains a reference to cell C3 it is referring to
one column to the right and one row down. If you copy the formula to another location
the reference will still be to one column to the right and one row down and so the
formula will change.

An absolute cell address is the exact location of a cell. If you copy the formula to
another location the formula will stay the same. Absolute formulas contain a dollar
sign ($) before each part of the cell address that will be exact. For example $C$3 will
always refer to C3 while $C3 will always refer to Column C but the row will be in
relation to the location.

Excel spreadsheets for PC

Reggie Kopecky 1/99