1

I'm working in an excel spreadsheet that I add data to each day as new data comes in. Some columns are formulas calculating things based on the new data. Some of these columns have managed to automatically copy the formula for the past several days as the new data is entered into the new row. As I have increased the number of columns and thereby the number of calculation columns, I've noticed that the newly inserted columns won't do the same automatic filling as the previous columns, and I'm not sure why. The formulas are a simple copy down the column, but I would like each new row to automatically figure out the formula once the data is entered into the new row.

For example: Column A is a number Column B is a formula - =A2-A1 Column C is a rolling average - =AVERAGE(B1:B3)

My current sheet will fill in the formula for column B once I input data in column B, but will not do the same for column C

Elliott
  • 11

1 Answers1

0

I've found Excel tables to be very valuable for managing this type of auto-fill.

  1. Select all of your data, including your column headers.
  2. On the "Insert" tab, select "Table."
  3. Check the box which indicates that your data has headers.

Now, when you enter a formula in one cell in a column, Excel will automatically fill the other cells in the column with that formula.

When you add a row to the table, the formulas will be added.

DeNaeL
  • 193