You can quickly create a named range in Excel, but it doesn't automatically expand to include new items that are added at the end of the list.

If you plan to add new items to a list, create a dynamic named range, by using an OFFSET formula. In this example, the formula entered in [...]