Entering Data in Microsoft Works Spreadsheets

01
of 06

Planning Your Microsoft Works Spreadsheets

Microsoft Works Spreadsheet Tutorial
Microsoft Works Spreadsheet Tutorial. � Ted French

Planning a Works Spreadsheet

Entering data into a Microsoft Works spreadsheet is as easy as clicking on a cell, typing a number, a date, or some text and then pressing the ENTER key on the keyboard.

Even though it is easy to enter data, it is a good idea to do a bit of planning before you begin to type.

Points to consider:

  1. What is the purpose of the spreadsheet?

  2. What information needs to be included?

  3. What headings are needed to explain the information in the Works spreadsheet?

  4. What is the best layout for the information?
02
of 06

Cell References in Microsoft Works Spreadsheets

Microsoft Works Spreadsheets Tutorial
Microsoft Works Spreadsheets Tutorial. � Ted French

Cell Facts

  • Data is stored in cells in a Microsoft Works spreadsheet.
  • Each small rectangle in a Works spreadsheet is a cell.
  • A cell is the intersection point of a column and a row in a spreadsheet.

Spreadsheet Facts

  • Columns run vertically in a spreadsheet and are identified by a letter.
  • Rows run horizontally and are identified by a number.
  • There are 16,384 rows, over 200 columns, and almost 4 million cells in each Works spreadsheet.

Cell Reference Facts

  • To keep track of all these cells, each cell has a cell reference or address.
  • A cell reference is a combination of the column letter and the row number.
  • The active cell reference is shown in the name box above column A.
03
of 06

Microsoft Works Spreadsheets Data Types

Microsoft Works Spreadsheets Tutorial
Microsoft Works Spreadsheets Tutorial. � Ted French

There are three main types of data used in Microsoft Works Spreadsheets:

  • labels
  • values
  • dates/times

A label is an entry that is usually used for headings, names, and for identifying columns of data. Labels can contain letters and numbers.

A value contains numbers and can be used in calculations.

Date/time data is just that, a date or the time entered into a cell.

04
of 06

Widen Columns in Microsoft Works Spreadsheets

Microsoft Works Spreadsheets Tutorial
Microsoft Works Spreadsheets Tutorial. � Ted French

Widen Columns in Microsoft Works Spreadsheets

Sometimes data is too wide for the cell it is located in. When this happens, the data may or may not spill over into the cell beside it.

  • If a label is too long for a cell but there is nothing in the cell to the right of it the label simply spills over into the space to the right (see cell B2 in the image above).

  • If a label is too long for the cell but there is data in the cell to the right, the label is cut off. The rest of label is still present, there just isn�t room to display it (see cell B4 in the image above).

If a label is cut off, you can widen the column to display it. In Microsoft Works spreadsheets, you can't widen individual cells, you must widen the entire column.

Example - Widen Column B:

  • Place your mouse pointer on the line between Columns B and C in the column header.
  • When the pointer changes to a double headed arrow, click with the mouse button and drag to the right.
05
of 06

Widen Columns in Microsoft Works Spreadsheets (con't)

Microsoft Works Spreadsheets Tutorial
Microsoft Works Spreadsheets Tutorial. � Ted French

Widen Columns in Microsoft Works Spreadsheets (con't)

  • In Microsoft Works Spreadsheets, if a value is too long for a cell, it does not spill over to adjacent cells even if those cells are empty. The column needs to be widened before the value can be displayed.

In the image above, the number signs in cell B2 (####) indicate that there is a value (number) in that cell.

Example - Widen Column B:

  • Place your mouse pointer on the line between Columns B and C in the column header.
  • When the pointer changes to a double headed arrow, click with the mouse button and drag to the right.
06
of 06

Editing Cells in Microsoft Works Spreadsheets

Microsoft Works Spreadsheets Tutorial
Microsoft Works Spreadsheets Tutorial. � Ted French

Change Complete Cell Contents

  • In Microsoft Works spreadsheets to change the contents of a cell, click on the cell, type over the existing entry, and press the ENTER key on the keyboard.

Change Part of the Cell Contents

  • Method 1
    • Click on the cell to make it the active cell.
    • Click on the data in the formula bar.
    • Delete the part to be changed and type in the new data.
    • Press the ENTER key.
  • Method 2
    • Double click on the cell.
    • Edit the part of the cell you want to change.
    • Press the ENTER key.

In the example above, the highlighted numbers 5,6 and 7 in the formula bar can be removed by pressing the DELETE key on the keyboard and replaced with different numbers. Other Articles in this Series

Was this page helpful?