Publishers of technology books, eBooks, and videos for creative people

Home > Articles > Productivity

  • Print
  • + Share This
This chapter is from the book

change a value

In reviewing this worksheet, I realize that we made an error when entering values. The actual sales amount for the month wasn't 8103 as we entered. It was really 9103! Better enter the correct value now.

one.jpg Activate cell C3.

two.jpg Type 9103. This new value overwrites the value already entered.

three.jpg Press Enter (Windows) or Return (Mac OS).

The value changes, but what's more important is that all of the formulas that referenced that value, either directly or indirectly, also change. Compare the orange highlighted cells in this illustration with the same cells in the illustration on the previous page to see for yourself.

This is the reason we use spreadsheet programs!

  • + Share This
  • 🔖 Save To Your Account