A studio tracks 8 January, 12 February and 10 March reservations in columns C:E. Put =SUM(C2:E2) in F2, headed Q1 reservations. That label should make sense even when the months are hidden.

Group only the monthly columns

Select columns C:E in Ulet and choose Data → Group → Group Columns. Use the outline control to collapse the group. The Q1 value in F should remain visible and should still be 30.

The expanded view shows 8, 12 and 10 monthly reservations, with the total in F.

Illustrated outline selection for columns C:E.

Expand, save and reopen

Expand the outline and confirm the three source values still appear. After reopening the XLSX, try both views again. If F disappears on collapse, ungroup and recreate the span with only C:E.

The collapsed view still shows the Q1 total of 30.

Illustrated saved-view check.

Related Microsoft Excel reference