+ Reply to Thread
Results 1 to 2 of 2

Applying formula in a column for new rows inserted ?

  1. #1
    Forum Contributor
    Join Date
    07-15-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    116

    Applying formula in a column for new rows inserted ?

    Hi,

    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.

    Regards
    Andy

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Applying formula in a column for new rows inserted ?

    Hi,

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 12-09-2013, 09:05 PM
  2. [SOLVED] applying a formula to many rows
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2012, 08:03 AM
  3. Replies: 6
    Last Post: 02-16-2012, 04:52 PM
  4. Replies: 1
    Last Post: 09-02-2010, 12:39 AM
  5. AUTO INSERT A COLUMN'S FORMULA IN MANUALLY INSERTED ROWS
    By JLah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2006, 11:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1