How to Create a Spreadsheet with Microsoft Works - dummies

How to Create a Spreadsheet with Microsoft Works

By Nancy C. Muir

Microsoft Works includes a spreadsheet program you can use to organize data and perform calculations. Microsoft Works Spreadsheet uses a grid-like structure for entering data (text or numbers).

The individual cells of the grid are formed by the intersection of a row with a column, so a cell is identified by a column letter followed by a row number. For example, B3 identifies the cell located at the intersection of the second column over and third row down.

1To start a new spreadsheet choose Start→All Programs→Microsoft Works→Microsoft Works Spreadsheet.

Spreadsheet starts, and displays a blank spreadsheet.

If you’re already working in Spreadsheet, you can start a new spreadsheet by choosing File→New. To open an existing spreadsheet so you can make changes to it, choose File->Open to locate and open it.

2Click in a cell.

When you click in a cell, it’s surrounded by a border to show that it’s active.

3Type data (text or numbers) into the cell.

Notice that what you type appears in both the cell and the Formula bar.

If your laptop doesn’t include a number pad, press the Fn (Function) key on your keyboard, and then press any of the keys that display the numbers 0 through 9 next to the letters to enter those numbers.

Use the two scrollbars, the one to the right and the one at the bottom, to move vertically or horizontally through a large spreadsheet.

4Press Tab to complete the entry and move to the next cell.

You can also click the Enter button, which looks like a check mark, to complete your entry and keep the current cell active.

To make changes to a cell, click it and edit the contents displayed in the Formula bar.

Remember to save your work often to avoid losing anything. Choose File→Save, type a filename for the spreadsheet, then click Save. After saving the spreadsheet for the first time, you can keep working on it if you like; just click the Save button on the toolbar or choose File→Save to save any changes you make.