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

Home > Articles > Productivity > Microsoft Excel

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

  1. Activate cell C3.
  2. Type 9103. This new value overwrites the value already entered.
  3. Press Enter.

    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 spread- sheet programs!

  • + Share This
  • 🔖 Save To Your Account