Microsoft Works for Windows Spreadsheet Instructions

How Do I:
Start a new spreadsheet?
Duplicate data?

How to Start a New Spreadsheet

  1. Open Microsoft Works and choose Spreadsheet from the Works Tools.

  1. Before entering information, plan where you want labels, headings, values, and formulas. Things can be moved, but it is easier to set it up correctly from the beginning.

  2. Click in a cell and type. Press enter to put the information in the cell.

  3. To enter a formula in a cell, type = first and then type the formula.

To Duplicate Data - To duplicate information in a cell, you can copy and paste, fill down, or fill right.

To Copy and Paste

  1. Click in the cell you want to copy.
  2. On the menu, click  Edit - Copy OR click the Copy Button OR Ctrl-C on the keyboard. 
  3. Click in the cell where you want to paste.
  4. On the menu, click Edit - Paste  OR use Paste Button OR Ctrl-V on the keyboard.

To Fill Down

  1. Click in the cell you want to copy.
  2. Click, hold, and drag down through the cells in which you want to paste.
  3. On the menu, click Edit - Fill Down OR 
    Ctrl-D on the keyboard.
  4. In this example, 1 would appear in the 4 dark cells.

To Fill Right

    1. Click in the cell you want to copy.
    2. Click, hold, and drag right through the cells in which you want to paste.
    3. On the menu, click Edit - Fill Right  OR Ctrl-R on the keyboard.

<< Previous  

Table of Contents 

Last edited 6/4/01