Watch how easy it is to add more data to Tables in Excel Video 397. If you’ve ever manually shaded every other row in a report, I hope those days are over with this Excel Video. Watch how I can add a formula to one adjacent cell in a Table and Excel will automatically copy the formula to the rest of the column in the Table. I can add a row to the Table and the formulas we created earlier automatically include the new row. As I add the data, the shading and other cell formatting changes automatically.
These tricks are generally all that you need to add data to Tables. Stay tuned. Next time I’ll show you another way to add data when these methods won’t work.
