If all you want is to not 'expand' the sales, first collaspe the form. Then delete .Range from column A for the Sales line, but not the row for Expenses. Thus when you expand the SmartSheet, the sales will remain summarized, but the Expenses will show each account on separate rows.