CODEWITHSUNDEEP
excel
Ropstah
Ropstah

Reputation: 17804

Excel - How to persist function in column when row data is cut or deleted?

is is possible in Excel to have some sort of fixed function defined for a entire column? This function needs to persist when a row is deleted, and it needs to 'exist' when new row data is added...

So in the example below, If I cut row 1 to row 3 (so the worksheet is empty), I want the 'new' row 1 to have the function in column D already defined (which is actually: multiply the value from C from the same row with 10)... Is this possible?

-----------------------------------------
|    A    |    B    |    C    |    D    |
-----------------------------------------
|    1    |    1    |    1    |=C1 * 10 |  --- ROW 1
-----------------------------------------
|    1    |    1    |    1    |=C2 * 10 |  --- ROW 2
-----------------------------------------
|    1    |    1    |    1    |=C3 * 10 |  --- ROW 3
-----------------------------------------
|         |         |         |         |
-----------------------------------------
|         |         |         |         |
-----------------------------------------

Upvotes: 1

Views: 1409

Answers (2)

Robert Mearns
Robert Mearns

Reputation: 11996

In Excel 2007 this type of functionality is built in, so long as the data is marked as a table.

Select your data range and click on 'Insert - Table' alternately Ctrl-l or Ctrl-t

Add a new column heading and your formula next to the last column of data. The table will automatically expand to include the new column. It will automatically copy the formula down to all rows.

Any new rows added will automatically have the formula included.

Upvotes: 1

user110714
user110714

Reputation:

If you copy the cell with the function in it, then click the column header (to select all of it) that you want the function to persist in, then right click - paste special - formuals, that should do the trick.

Upvotes: 0

Related Questions