1. Home
  2. Computing & Technology
  3. Spreadsheets

MS Works Spreadsheets Formulas

By , About.com Guide

4 of 8

Updating MS Works Spreadsheets Formulas

MS Works Spreadsheet Formulas

MS Works Spreadsheet Formulas

© Ted French

Updating MS Works Spreadsheets Formulas

When you use cell references in an MS Works spreadsheet formula, the formula will automatically update whenever the relevant data in the spreadsheet changes.

For example, if you realize that the data in cell A1 should have been an 8 instead of a 3, you only need to change the contents of cell A1.

MS Works updates the answer in cell C1. The formula, itself, doesn't need to change because it was written using cell references.

Changing the data

  1. Click on the cell A1
  2. Type an 8
  3. Press the ENTER key on the keyboard

The answer in cell C1 where the formula is, immediately changes from 5 to 10, but the formula itself is unchanged.

Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Other Spreadsheets
  5. MS Works Spreadsheets
  6. MS Works Spreadsheets Formulas - Using Ms Works Spreadsheets Formulas - MS Works Tutorial

©2009 About.com, a part of The New York Times Company.

All rights reserved.