When you declare a range as a table in Excel 2007, any calculations entered to the right of the table are automatically copied throughout the table. Episode 987 talks about how to solve this problem.
This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!