+ Reply to Thread
Results 1 to 2 of 2

Table doesn't automatically fill new cells with surrounding formulas of a column

  1. #1
    Registered User
    Join Date
    08-24-2018
    Location
    Berlin, Germany
    MS-Off Ver
    2016
    Posts
    1

    Table doesn't automatically fill new cells with surrounding formulas of a column

    The problem: in my table, filled with rather complex cell formulas, I want to insert new lines. When inserted, the formula of the respective column should be automatically inserted. It currently works for some columns (In the screenshot green ) and doesn't for others (In the screenshot white). I do not know why it doesn't work for some columns. Screenshot: Rows 91 and 92 and are inserted here.

    (unfortunately i cannot upload the screenshot, since it is my first post. but i hope you can imagine...)
    *
    How can I modify this table so that all columns automatically insert the right formula for each respective column? I.e. the formula that all existing cells of this column already contain?
    *
    My assumption: it doesn't work since it is a named table and when I created it I was initially asked whether the formulas for a column should be inserted in all cells of this column. Perhaps I didn't say yes for all columns consistently. Maybe the problem is related to this?
    *
    The table is already filled with many values and I want to continue using it. Any help is welcome how I can modify this existing table so that the new inserted rows automatically adapt the formula of the specific column.
    Anybody knows how this could work?

    Thanks a lot!
    Matthias

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Table doesn't automatically fill new cells with surrounding formulas of a column

    If your assumption is correct...

    1. Go to Table Tools. Find "Convert to range". With any cell in the table active,convert to range.
    2. Now ensure all the rows have the formulas that you want, ensuring formula is consistent within the column.
    3. Select data range and reconvert to table.

    When you add new line, formula will auto populate.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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-15-2017, 10:42 PM
  2. Replies: 3
    Last Post: 07-12-2017, 04:44 AM
  3. Automatically scrolling down a column to fill blank cells
    By lbl159 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2015, 03:15 PM
  4. Search Surrounding Cells and Use Logic Table to Highlight cells
    By Hekagigantes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 08:36 AM
  5. Fill column to end cell of surrounding columns, but with new data
    By Villis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-31-2011, 06:44 PM
  6. [SOLVED] How to select cells (located in a column) for formulas in a row automatically?
    By Dmitry Kopnichev in forum Excel General
    Replies: 3
    Last Post: 10-11-2005, 03:05 PM
  7. How to select cells (located in a column) for formulas in a row automatically?
    By Dmitry Kopnichev in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2005, 03:05 PM

Tags for this Thread

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