In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find.

Fortunately, a few quick formatting tricks will make them stand out, loud and clear. How to format subtotals in Excel What this list needs is some formatting to make those vendor subtotals stand out.