Is there a way to shrink an Excel table to fit the data? -

i have excel table has several other places in spreadsheet using various reasons, , realized table had bad data. collected new data, , there fewer rows in new data set in previous table.

is there way can shrink table reflect new count of data?

not @ sure understand requirement i'm guessing want reduce size of tables/table without deleting entire rows in spreadsheet (because of content present elsewhere in spreadsheet in same rows table data).

if so, merely select area of table deleted , press delete. if want remove formatting remains select angle icon shown @ extreme bottom right of table , drag suit.

i assuming (table) rows deleted contiguous block @ bottom of table.