Select the data range, B3:E16–you want to highlight the entire row. If you use a Table, Excel will update range as you add and delete records. The demonstration file contains a Table example.

Even the simplest spreadsheets—budgets, lists, trackers, and the like—can benefit from the powerful features in Excel that ...