For Seniors: Create Shortcuts to Favorite Files and Folders
For Seniors: Play Solitaire on a Windows Computer
For Seniors: Format Text in a Microsoft Works Document

For Seniors: Create a Spreadsheet with Microsoft Works

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.

1

To 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.

2

Click in a cell.

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

3

Type 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.

4

Press 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.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
For Seniors: Find Windows' Gadgets Online
For Seniors: Apply AutoFormats to a Microsoft Works Spreadsheet
For Seniors: Use a Laptop's Windows 7 Start Menu
For Seniors: Print a Microsoft Works Document
For Seniors: Play Chess Titans on a Windows Computer
Advertisement

Inside Dummies.com