Thanks to this, the formula will work even if the order of the columns will be shuffled in the register table and database. The fill handle option is turned on in excel by default. Tables Powerpoint Templates Powerpoint Templates Invoice Design Templates It's good to know how to get to this window because once you turn auto fill off, you won't see the autocorrect options menu anymore until you. Excel autofill not working in table . Download the example of autocomplete cells from the another table. Check the box that says fill formulas in tables to create calculated columns. Let's assume that first row is 3 and you wanted to fill it in column b. Enable or disable the autofill feature in excel. These are not external queries converted from a previous version of excel; In excel, there are many ways to quickly and efficiently fill cells with data. Put following formula in b3 and drag down. I built them in excel 2007, and the issue persists across multipl...