I have a spreadsheet where I'm doing a whole table of calculations. I'm playing with the calculations and seeing what it does to the data. I expect to change the calculations dozens of times (at least) during this process.
When I change the calculation, I then have to highlight the cell, grab the handle, and drag it to the bottom of the column. Then I have to highlight the column, grab the handle, and drag it all the way to the right of the spreadsheet. This will then copy this updated calculation to all of the cells in the sheet.
How can I get this to happen automatically? When I change the formula in the top left cell, I want this change to replicate to all of the other cells automatically. Is this even possible?