Excel appears to group rows automatically

[jpaul_johnson]

I have a couple spreadsheets that contain a bunch of labels and data separated by blank rows. Sometimes I open a workbook and there are groups set, as if Excel was trying to determine data ranges for me. I don't want Excel trying to do this for me, and I have to select each group and ungroup it. There were 7 in my current worksheet.

I'm assuming that Excel is doing this because I'm not doing it intentionally. I don't know how it's happening.

I'm using Excel 2007 with Windows 11.

How do I disable this automated grouping?