Welcome to Using Google Sheets!

Important Info on Cell Formulas, Duplicating Google Sheets


Takeaways:

  • All of these cell formulas are based on the CELL INDEX value (A1, H9, E3, etc.)
  • So if you move data from one section of the sheet to another, please make sure that your formulas are updated with the correct cell indexes!
  • If your formula was = G14 + D20 but then you move your data from G14 to another part of the Google Sheet, then that formula will no longer work the way you intended it to (which is why we must update it!)