You also can't use spilled arrays in formatted tables, another reason to avoid this approach. Another alternative is to format the cells directly with borders and row colors. As with Excel's table ...