SPREADSHEETS TUTORIAL
COLUMNS AND ROWS
Widening Columns
To select a column, click in the column heading of the column
To select columns, click in the column heading of the columns
you wish to widen.
Hold down the [Ctrl] key to choose more than one column.
The column width may be changed by choosing:
1. Format ---> Column Width
2. Enter the width of the column
3. Press [Enter] or click on OK button.
NOTE: If you click on Best-fit, Excel will
widen or narrow the column according to the data in the column.
Or
1. Use the mouse and place the pointer on a divider between
the two column headers
The cross (+) will change to a dual arrow symbol.
2. Click and drag the column to the width desired.
To produce the following sample on your screen, follow the
steps in exercise below.
Building the worksheet
Inserting /Deleting columns and rows
To insert a column or row:
1. Click on the column or row label
2. Choose Insert ----> Columns/Rows.
| Remember: If you selected an entire column
or row by clicking on the column letter or row number,
the insertion will now occur. |
Formating numbers
When a number is entered into a cell the default is in the
GENERAL format.
To select a different format choose:
1. Format ---> Cells ---> Number. The following
screen is displayed:
2. Select the desired format.
3. Press [Enter] or click OK button.
The format is applied to any selected cells.
NOTE: When a format is selected a sample of that format is
shown beside samples in the dialogue box.
Formating text
To select a different format choose:
1. Format ---> Cells ---> Font tab. The
following screen is displayed:
2. Use the scroll bar to view all the available fonts
3. Select a desired size for the selected font
5. Press [Enter] or click on OK button
The format is applied to any selected cells that contain
text.
Aligning cell contents
To alter the alignment of cell contents, choose:
1. Format ---> Cells ----> Alignment tab.
The following screen will appear:
2. Click on the desired alignment.
3. Press [Enter] or click the OK button.
|
