Do you select the range and do Insert—>Table? Using an actual table is much better in Excel and the lack of this confuses me in Sheets but that’s probably just because I’m better trained in Excel.