Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
If I update the top-left cell, I can select it and double click on the handle. This copies the formula to all of the cells directly below, which seems like half the problem. This is still a manual solution, though, and I would like an automatic one. – Erick Robertson Dec 3 '11 at 19:08
up vote 2 down vote accepted

Instead of filling down then filling across you can copy the cell in the top-left corner, then select the entire range (Ctrl+Shift+End) and do Paste.

If you truly want something automated, you'll need to use VBA. This would be done with the Worksheet_Change event. Let me know if you want that solution.

share|improve this answer
That's easy enough that I can do it manually. Thanks! – Erick Robertson Dec 3 '11 at 19:52
  1. Select all the cells with the formula
  2. Change the formula in the formula bar
  3. Use the ctrl-Enter combination instead of Enter

The new formula will be replicated in all the cells, while still keeping them selected.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .