Expand tables automatically and add totals

- [Instructor] When we work with tables in Excel, … the whole issue of working with rows and columns … is a bit different. … First of all, do notice this fact about tables. … Anytime we add information in the column … just to the right of the table or on the row just below, … that information immediately becomes part … of the table, even with just a heading. … So in cell L1, I'm going to put in a new heading here, … New Salary eventually we'll have formulas in this column, … but as I type this and press Enter, what happens? … That column is part of the table. … Now format doesn't look so good, so I'll simply take … the cell to its left and with the right mouse button drag … an edge rightward into cell L1 copy here as formats only. … Now I want to put in a new record above row seven here, … and if this were standard, non-table Excel here … I would highlight these cells, right click and insert. … Not difficult, anything like that. … We can do the same thing here, … but we don't even have to highlight all those cells. …