Applying formula in a column for new rows inserted ?
I've applied a basic multiplication formula =D12*E12 in a table Column F, also i've filled it throughout
but now if new rows are inserted in between or at the end of the table, new cells in this columns
doesn't include this formula. Kindly pls help.
Re: Applying formula in a column for new rows inserted ?
Please format the whole range as a table using "Format Table" option. This would automatically update the formula for the new rows added in between or at the end.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Curious Dude in forum Excel General
Last Post: 12-09-2013, 09:05 PM
By Vogelmann in forum Excel Programming / VBA / Macros
Last Post: 10-17-2012, 08:03 AM
By benoj2005 in forum Excel General
Last Post: 02-16-2012, 04:52 PM
By arslanchatha in forum Excel General
Last Post: 09-02-2010, 12:39 AM
By JLah in forum Excel Formulas & Functions
Last Post: 01-20-2006, 11:15 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1