Skip to main content
edited tags
Link
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195
Post Migrated Here from superuser.com (revisions)
Source Link
Joe Bobby
Joe Bobby

Applying a Formula to All Cells in a Column (Even New Cells)

I'm using Google Spreadsheets and currently, this is what I have in J2: =iferror(H2/G2,0)

I know I can double click the square in the bottom right and it will apply to every cell in the column but if I were to create a new row anywhere in the spreadsheet it would show up as empty. I just want every cell including Newly created cells to be filled with the formula above so it will display the correct data for that row. How do I do this?