Autofill formulas when adding rows in tables

  • Thread starter Thread starter FredZack
  • Start date Start date
F

FredZack

Is it possible to have the formulas you are using in a column automatically
appear in the new cell in the column when you add a new row? I swear I saw
this demonstrated in a video but they did not explain how to do it.

I just converted a table of data to an Excel Table (using Format as Table
command); took out an old forumla (at top cell of data in column) and then
reentered in strcutured reference. I then copied down the entire column. But
when I add a new row to the table that new cell in that column does not have
the formula.

Did I imagine that video or am I missing a step? I hope I do not have to go
through adding the column to the table from scratch - this workbook has many
worksheets and columns already in place.
 
I think the formula gets copied down WHEN you ADD a new column; ie, when you
type a formula in the 1st column to the right of the table, it creates a new
column and fills in all rows with that formula.

Good Luck.
 
Back
Top