How to Format a Spilled Array in Excel
Don't apply direct formatting.
In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array—applying direct formatting will cause issues if the size or shape of the data changes.
