I use Excel tables a LOT, and and have grown to love what they add to the capabilities with Excel. I'm stumped by a particular table that I have, and could use some insight. Typically, as information is added to any of the fields immediately below or to the right of a table, the range of the table will expand to accommodate the new fields. If I have formulas in my table and add a new row to the bottom, the formulas and formatting typically copy down into the new range as well. I have a particular table for which this has not proven true. Each time I add new data, I have to copy all of my formulas and formatting, and this has become frustrating. As yet, I have not found any particular settings that would control this behavior of Excel. Geniuses, what say you?
Bookmarks